Copy and Paste question

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
Insert this line after the pasting is done, it will clear the clipboard:

Application.CutCopyMode = False


hth
knut egil
 
Back
Top