Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating New sheets
Hi All
I have a programme that creates a fair number of sheets, but if I run it about 2 - 3 times then Excel bugs out with the error message of "Copy method of Worksheet Class failed". The problem isn't to do with the amount of worksheets in the book as each time I delete them before I start, so as far as I can workout each time that I create a new worksheet excell puts something in memory and when it's memory gets full it spits out an error. I have no idea how to fix this and any advice would be greatly appreciated. Thanks Heaps Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating sheets | Excel Discussion (Misc queries) | |||
Creating Sheets from a List | Excel Discussion (Misc queries) | |||
Macros-creating new sheets | Excel Worksheet Functions | |||
Creating new sheets | Excel Discussion (Misc queries) | |||
Creating separate sheets from a list | Excel Programming |