clearing memory /clipboard
 

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?

clearing memory /clipboard
 

Near the end of your code after work is done the line:
application.CutCopyMode = False 'this empties the
Clipboard


-----Original Message-----
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?
.