Turn of question

Hi,

I want to copy a huge amount fo data from a file to an other one in a macro.
When I copied the data to clipboard and I want to close the source file a question will appear " There is large amount of information on Clipboard. ...
Yes No or Cancel" I want to skip this question. How can I turn it off and keep the copied data on Clipboard?

Thanks for your tips.

Gabor

Hi

Application.DisplayAlerts =False

HTH
Carim

Sorry I forgot to mention the instruction is to be inserted into your macro ...

HTH
Carim

Hi,

Thanks a lot!

Gabor

Thanks for the feedback ...

Carim