Option Explicit
Dim myrng As Range
Dim rowcount As Byte
Dim cell As Variant
Dim MyArray() As Variant, temp As Integer
Sub filterwithdynamicArray()
rowcount = Sheets(1).Range("H2").End(xlDown).Row
temp = 0
Set myrng = Sheets(1).Range("H2:H" & rowcount)
For Each cell In myrng
temp = temp + 1
ReDim Preserve MyArray(1 To temp)
MyArray(temp) = cell
Next cell
Sheets(1).Range("A1").AutoFilter field:=2, Criteria1:=MyArray, Operator:=xlFilterValues
End Sub
File to download:
https://drive.google.com/file/d/0B23eJ2xd9ODyWVFsYVhYZkxJODQ/edit?usp=sharing
No comments:
Post a Comment