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

after each paste and before closing

application.CutCopyMode = False

or around the closing command

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

--
Regards,
Tom Ogilvy

"WendyUK" wrote in message
...
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

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

Wendy x

"Tom Ogilvy" wrote:

after each paste and before closing

application.CutCopyMode = False

or around the closing command

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

--
Regards,
Tom Ogilvy

"WendyUK" wrote in message
...
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