View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CWillis
 
Posts: n/a
Default Sheet activation

The following code opens sheet1. When I uncomment sheet 12 and comment
sheet1, it gives the error: "Run-time error '57121': Application-defined or
object-defined error" Sheet12 exists. Any ideas? Thanks.

Sub testing()

Sheets(1).Select
'Sheets(12).Select

End Sub