Posted to microsoft.public.excel.programming
|
|
Results of Advanced Filter to Array
Thanks, Alan.
James
Alan Beban wrote:
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]
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then
instead of using the Advanced Filter you could use
arr = ArrayUniques(Selection)
Alan Beban
|