View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Loz Bingley Loz Bingley is offline
external usenet poster
 
Posts: 3
Default 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