| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieve information from clipboards not in the reading pane | Excel Discussion (Misc queries) | |||
| Prevent Overloaded variables | Excel Discussion (Misc queries) | |||
| Difference betweeen Windows and Office Clipboards? | Excel Discussion (Misc queries) | |||
| How do I find 1 of the 24 clipboards that excel says I have? | Excel Discussion (Misc queries) | |||
Hybrid Mode
