Clipboards Overloaded?
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
|