Do you wish to clear clipboard memory?

[Guest]

I have a macro that is accessing multiple spreadsheets and extracting data
and pasteing to a summary spreadsheet.

This is working fine, except when it closes each sheet, I get the message
"You have data in your clipboard do you wish to save or clear memory" - how
can I skip this or switch it off?

Any help would be gratefully received, its driving me nuts - whats the point
of having a macro if I have to sit there and press return after each
update!!!

Thank you,

Wendy
Telford

 

[Tom Ogilvy]

after each paste and before closing

application.CutCopyMode = False

or around the closing command

Application.DisplayAlerts = False
' closing code
Application.DisplayAlerts = True

 

[Guest]

You are a wonderful person, and have saved my sanity - thank you so much.

Wendy x