recrding macro,copy data thn close file, get messge abut clpbord

P

PaddyBoy

While recording a macro I copy data from one spreadsheet and paste to
another. When I close the original sheet I get a message saying the clipboard
is full, I'm forced to cancel this command and it locks up the macro when I
run it in the main file. How do I turn of this info?
 
D

Dave Peterson

You could add one more line before you close the workbook.

application.cutcopymode = false
 
P

PaddyBoy

Thanks Dave. I'll try this and see how it runs. I figured there was a
application command.
 
Top