Jim

After the copy and paste is complete and before you close the file add this
line

Application.CutCopymode = False

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 03:05:02 -0800, jamessinc
wrote:

I have a macro that will open a file and copy a range to another file. Then
I will close the file I copied the range from but I am asked if I wish to
clear the clipboard after each copy. How do I stop the clipboard request
from stoping the macro?

Thanks
Jim