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
|