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

.