Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004
Please can someone help me...
I am using excel 2000 and have write a macro in VBA to copy a worksheet and then rename the copied sheet. My problem is that are loop 23 time I get the error Copy of worksheet clas failed Run time Error 1004. I have looked at some example were other people had the same problem but when I use the code i must be doing something wrong. My code reads Sheets("ReconMaster").Select Sheets("ReconMaster").Copy After:=Sheets(7) Sheets("ReconMaster (2)").Select Sheets("ReconMaster (2)").Name = strSheetN Once the sheet is copied I rename based on an Emplyee number. I have about 100 sheets to create. Can someone help me get over this problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) |