View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default 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