Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subscript out of range error: tyring 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: tyring to copy a hidden sheet
You shouldnt need the "hidden"
"sam" wrote: Worksheets.Copy Worksheets("Sheet2") should work fine 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
subscript out of range error: tyring to copy a hidden sheet
If you want the copy to be hidden also set it to visible = false.
If you want it to folow after a certain worksheet set it to copy after:= etc and perhaps give the copy a name of your choice. Worksheets("Sheet2").Copy After:=Worksheets("Sheet1") ActiveSheet.Name = ("name of your choice") ActiveSheet.Visible = False good luck john |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
subscript out of range error: tyring to copy a hidden sheet
I dont know about copying your worksheet! you certainly seem to have coppied your question successfully a few times. I hope some of the answers prove useful good luck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subscript out of range error: tring to copy a hidden sheet | Excel Programming | |||
Subscript out of range error - selecting a sheet | 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 |