Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subscript out of range error: tring to copy a hidden sheet
I got a subscript out of range error when trying to copy sheet2. Sheet2 is
hidden. here is the code: Worksheets("Hidden").Copy Worksheets("Sheet2") Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subscript out of range error: tring to copy a hidden sheet
Sub copyhiddensht()
Sheets("Sheet2").Copy after:=Sheets(Sheets.Count) ActiveSheet.Name = "newsht" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "sam" wrote in message ... I got a subscript out of range error when trying to copy sheet2. Sheet2 is hidden. here is the code: Worksheets("Hidden").Copy Worksheets("Sheet2") Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subscript out of range error - selecting a sheet | Excel Programming | |||
Copying Sheet - subscript out of range error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
In multiple sheet copy error subscript out of range ?? HELP | Excel Programming |