Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the need to programmatically create up to 100
worksheets in a workbook. I have run into a limitation that hopefully has an answer. After about 20 to 30 copy before comands, if bombs. I can save my changes exit excel reopen and continue to add worksheets. It appears there is a cache or memory buffer that i will have to clear after 20 worksheet copies before continuing but have been unsucessful thus far. Help. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |