View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Problem with "Application.Goto Reference" code line

In my Workbook_Open() subroutine, I run the following line of code:

Application.Goto Reference:=Sheets("Sheet1").Range("A1"), scroll:=True

This code works okay, but whenever I mark my "Sheet1" as hidden, the
code no longer works. The error message that I get is Run-Time
Error 1004 - Method 'Goto' of Object '_Application' Failed.

Is there any way to use that line of code on a hidden sheet??

thanx