Copy and Paste question

[Richard]

I have a macro that copies and pastes a large amount of data. After it has
run I get the question:
" There is a large amount of information on the clipboard. Do you want to
[keep it]?"

Could someone please tell me how I can avoid this question being asked as I
never wish to keep the data?

Many thanks

 

[DS NTE]

Insert this line after the pasting is done, it will clear the clipboard:

Application.CutCopyMode = False


hth
knut egil