clearing memory /clipboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Near the end of your code after work is done the line:
application.CutCopyMode = False 'this empties the
Clipboard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Clipboard command in Excel 2007 1
Clearing Office clipboard 2010 2
Delete duplicate rows using macro recorder 1
automate clear clipboard 2
advanced filter office 2007 1
Clear Office Clipboard from VBA? 22
PasteSpecial method of Range class failed Error 1004 8
Macro speed decreesing after each run 6

Back
Top