Copy unique values from autofilter

[jomili]

On my "View2Pivot" worksheet I have an autofilter applied. I want to copy only the unique, visible items from the second column in my autofilter range. I was hoping this code would do it for me, but I'm getting an error message saying "Object Variable or With Block Variable not set"

Please Login or Register  to view this content.

Here's the full macro:

Please Login or Register  to view this content.

[romperstomper]

You can't apply an advanced filter and an autofilter at the same time. You'll have to loop through the visible cells of the relevant column and add them to a collection (or dictionary) to get unique records.

[jomili]

I was afraid someone would say that. Oh well, back to the drawing board...