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

I dunno......I always use

Sheets("SheetName").Select
or
WorkSheets("SheetName").Select

Maybe just try re-typing, and try another two sheets to see if it's
something with that one sheet, or something in the code.......

hth
Vaya con Dios,
Chuck, CABGx3




"CWillis" wrote:

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