Clipboards Overloaded?

[Loz Bingley]

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

 

[Guest]

hi.
before each copy command insert the following
Application.CutCopyMode = False
that should clear up you problem.

 

[Loz]

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.

.

 

[Loz Bingley]

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

 

[Loz Bingley]

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!)