Hi I am writing a macro that copies and pastes alot of information fro
1 spreadsheet to another but because of the clipboard on office xp I a
running out of memory to complete the task and the macro has to end.

I have tried using the command

Application.CutCopyMode = False

But this does not seem to work!

Any ideas people!

Thank you in adavnce

--
James_Newto
-----------------------------------------------------------------------
James_Newton's Profile: http://www.excelforum.com/member.php...fo&userid=1832
View this thread: http://www.excelforum.com/showthread.php?threadid=46589