Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is a piece of a larger macro. What this is suppose to do is to
open up another workbook, then come back, and select the folder Official List. Then it's suppose to Goto a named ranged Age. If I run this little part without opening up the other file, it works fine. The strange thing is that even with the error on the line Application.Goto Reference:="Age" I see that it opened up the other workbook ok, and it selected the folder Official List ( I had selected a different folder prior to running the macro, to make sure that line worked.) The cursor is at A1. Why would that Goto line work when the other workbook is NOT opened, but but I get the error when it's not opened? I know using Goto is not acceptable to some, but I've tried using variations of a .Select command without success, and the Goto command always works for me..... Thanks for your help. J.O. Workbooks.Open Filename:= _ "\\ceddfssrv01\cedroot\public\Furniture Staging List\Year old list - Current Year.xls" ActiveWindow.ActivatePrevious Worksheets("Official List").Activate Application.Goto Reference:="Age" '<<<<error on this line ActiveCell.Offset(1, 0).Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
USING A GOTO COMMAND IN EXCEL | Excel Worksheet Functions | |||
Goto Command in Code | Excel Programming | |||
search or goto command needed. | Excel Programming |