| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow "Goto box" resized in Excel since long tab name problem | Excel Programming | |||
| Goto Reference:="abc" where abc is formula result | Excel Programming | |||
| Application.Goto Reference:="ActiveCell.Value"??? Whats wrong?? | Excel Programming | |||
| "On Error GoTo" syntax problem | Excel Programming | |||
| Application.Goto reference:="MyCell" | Excel Programming | |||
Threaded Mode
