Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy method of Worksheet class failed
Hello I Have the following code:
Worksheets("Data History").Copy after:=Worksheets("Adviser") and if produces this error: Run-time error '1004': Copy method of Worksheet class failed Both Sheets referenced in the code exist in the workbook. Any Ideas why this is happening. It only started recently. The code worked before. Regards and thanks for all help. Francis. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy method of Worksheet class failed
Hello.
I solved my own problem. entered line: Worksheets("Data History").Activate before the offending line and code now works. ? Why does it need this as the Worksheet is referenced explicitly. Regards Francis. "Francis Brown" wrote: Hello I Have the following code: Worksheets("Data History").Copy after:=Worksheets("Adviser") and if produces this error: Run-time error '1004': Copy method of Worksheet class failed Both Sheets referenced in the code exist in the workbook. Any Ideas why this is happening. It only started recently. The code worked before. Regards and thanks for all help. Francis. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
RE :Copy method of Worksheet class failed? | Excel Programming | |||
Copy method of Worksheet class failed? | Excel Programming |