Results of Advanced Filter to Array
I'm using this line of code to get unique values only. Is there a way
to get the results of the advanced filter into an array instead of
putting it on the worksheet? TIA, James
Range(Selection.Address).AdvancedFilter Action:=xlFilterCopy,
Unique:=True, Copytorange:=[h3]
|