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!