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