| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 9 when trying to copy a worksheet
The following code is part of a macro I have set up. The first two lines
(select "CR" and rename as "EQUIP-CR") work perfectly, but I get a run-time error 9 (Subscript out of range) when it gets to the copy worksheet line. Sheets("CR").Select ActiveSheet.Name = "EQUIP-" & ActiveSheet.Name Sheets("EQUIP-CR").Copy After:=ThisWorkbook.Sheets(Sheets.Count) I'm sure it is something very simple, but my VBA skills are limited and I haven't been able to figure this one out. Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run time error (Copy Method of Worksheet class failed) | Excel Programming | |||
| Run Time Error 1004 Copy method of Worksheet class failed | Excel Programming | |||
| Run-Time Error 1004 Copy method of worksheet class failed | Excel Programming | |||
| Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
| HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 | Excel Programming | |||
Threaded Mode
