Hi Guys,
As you can see from the code, i need to filter out multiple values in a column from the range ("$A$1:$H$195498) , the values to filter is about 718. I tried using the autofilter list to check numbers i need, this usually wont be a problem, but since the numbers are way too large, it is futile.
I tried inputting manually 718 numbers in the macro as shown in the code below but it errors after 100 numbers.
I also tried using advanced autofilter, but instead of filtering numbers i need, it came out with zero results.
Range("A1:H1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$H$195498").AutoFilter Field:=1, Criteria1:=Array( _
"10016080000160", "10016080018164", "10016080018415", "10016080018804", _
"10016080018829", "10016080018908", "10016080019000"), Operator:=xlFilterValues
After recording the macro I tried changing from criteria1:array(_"***","***" and so on to criteria1:range(H2:H718), excel just crashed!.
Can someone please help me solve this problem.
Bookmarks