Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clearing the clipboard | Excel Discussion (Misc queries) | |||
Clearing Memory | Excel Programming | |||
clearing the clipboard | Excel Programming | |||
Clearing clipboard | Excel Programming | |||
Clearing clipboard | Excel Programming |