Further info it appears that Excel did not crash but just
took several hours to complete the copy and paste process
(1 line in VB!)
-----Original Message-----
Update to the solution provided...
The CutCopyMode cleared the clipboard but it still "moved
on" to the next clipboard and so this solution did not
rectify the problem

Additional info - I am using Excel2000 on Win2000

-----Original Message-----
No this did not help
But thanks for trying
Loz
-----Original Message-----
hi.
before each copy command insert the following
Application.CutCopyMode = False
that should clear up you problem.

-----Original Message-----
Hi - I'm wondering if anyone out there can help me!

I have been writing a macro to copy worksheets from
one
workbook to another. Everything works fine but after a
number of pastes the system halts on me. I think the
error
(if it manages to come up with one before it hangs)
quotes
there being a problem in the method of
copying/selecting.

Is it possible that I have run out of clipboards? I
know
there now seams to be more than one. Can I copy to
just
one clipboard or clear them out before copying the
next
sheet over?

I would really appreciate a little help on this issue.
Many Thanks
Loz

.

.

.

.