Hi I am writing a macro that copies and pastes alot of information from
1 spreadsheet to another but because of the clipboard on office xp I am
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!


--
James_Newton
------------------------------------------------------------------------
James_Newton's Profile: http://www.excelforum.com/member.php...o&userid=18327
View this thread: http://www.excelforum.com/showthread...hreadid=465914

I've replied to your previous post in this NG.

James_Newton wrote:
Hi I am writing a macro that copies and pastes alot of information from
1 spreadsheet to another but because of the clipboard on office xp I am
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!