rdekanter
12-09-2018, 03:06 PM
Hi,
Normally to use .AdvancedFilter you would point to a range on a sheet that would be used as the criteria input.
E.g. I might want to filter based on a column called "UIN", in which case the criteria range might be A1=UIN, A2=UIN1, A3=UIN2. This would pick out any rows in my data that has a UIN of UIN1 or UIN2.
My question is: is it possible to use an array to house this information instead of looking to a range in a sheet?
Thanks in advance,
Normally to use .AdvancedFilter you would point to a range on a sheet that would be used as the criteria input.
E.g. I might want to filter based on a column called "UIN", in which case the criteria range might be A1=UIN, A2=UIN1, A3=UIN2. This would pick out any rows in my data that has a UIN of UIN1 or UIN2.
My question is: is it possible to use an array to house this information instead of looking to a range in a sheet?
Thanks in advance,