Not directly. You could run it, put the results range into an array and
clear the results range.

--
Regards,
Tom Ogilvy


"Zone" wrote:

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]