Large amount of info on the clipboard

[ledzepe]

Hi everybody,

My macro program involves moving large amount of info from one sheet t
another. I keep getting the message that "There is a large amount o
information on the Clipboard..." and is giving me the option to save i
or delete those info. I don't need those info anymore so I just click o
"No".

Is there a way to disable this message via macro or setting i
Excel/Windows

 

[Trevor Shuttleworth]

ledzepe

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

Regards

True

 

[Dave Peterson]

Application.cutcopymode=false

is another way.

Hi everybody,

My macro program involves moving large amount of info from one sheet to
another. I keep getting the message that "There is a large amount of
information on the Clipboard..." and is giving me the option to save it
or delete those info. I don't need those info anymore so I just click on
"No".

Is there a way to disable this message via macro or setting in
Excel/Windows?