Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Worksheets Error #1004 Work Around
Hi,
I have a workbook that has hidden sheets that I repeatedly copy and rename. I them populate them with data from a web page. I am planning to use a variation of the work around method from 'XL2000: Copying Worksheet Programmatically Causes Run-Time Error 1004' - 210684. Can I create a template from my existing workbook and place my worksheets that I have been copying and renaming in the template. I would like to import them back into my primary workbook and rename them. Will I have problems with the programing, menus and buttons that are part of those sheets? Is there any thing special I should be concerned with importing those sheets from the template? Why does it have to be a template? (I don't have a centeral site to palce the template). Thanks, Jim Wiley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004' on hiding worksheets | Excel Programming | |||
Run-Time Error 1004 Copy method of worksheet class failed | Excel Programming | |||
Range.Copy and error 1004 | Excel Programming | |||
error 1004 - metod Copy of class Range was failed | Excel Programming |