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

Clipboards Overloaded?
 

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

.

Clipboards Overloaded?
 

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

.

.

Clipboards Overloaded Still
 

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

.

.

.

Clipboards Overloaded Still - or not?
 

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

.

.

.

.