Can anybody help me with this. I'm using Excel 2002 and I created a query
that pulls records from an access database that I want to scrub for
duplicates. I created a macro to refresh my query and then filter unique
records from Column A and paste to Column C.

However when it filters the records, it's using the data from my previous
query. I currently have to run my macro twice to get it to work properly.
Is there anyway I can clear my memory/clipboard/whatever so I only have to
run my macro once?