PDA

View Full Version : [SOLVED] .AdvancedFilter using an array as the criteria



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,

Aflatoon
12-10-2018, 05:30 AM
Short answer: no.

rdekanter
12-10-2018, 05:42 AM
Thank you - I thought this might be the case and instead used a different method to achieve what I wanted.