Alerts
 

Hi..

I have a macro that opens one sheet copies a lot of data then pastes it into another but an alert comes up asking me if I want to save whats on the clipbard that halts the code...how can I get rid of this clipbard message..

Cheer

Jimbo

Alerts
 

Jimbo wrote:

Hi...

I have a macro that opens one sheet copies a lot of data then pastes it into another but an alert comes up asking me if I want to save whats on the clipbard that halts the code...how can I get rid of this clipbard message...

You could try using "Application.DisplayAlerts = False" before your code
and then "Application.DisplayAlerts = True" after the code is executed.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Alerts
 

another approach is to do

Application.CutCopyMode = False
after the paste. This will clear the clipboard.

--
Regards,
Tom Ogilvy

"Jimbo" wrote in message
...
Hi...

I have a macro that opens one sheet copies a lot of data then pastes it
into another but an alert comes up asking me if I want to save whats on the
clipbard that halts the code...how can I get rid of this clipbard message...

Cheers

Jimbo