.AdvancedFilter using an array as the criteria

[rdekanter]

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]

Short answer: no.

[rdekanter]

Thank you - I thought this might be the case and instead used a different method to achieve what I wanted.