LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Error with Goto command

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
command code ( GOTO command) in formula calan New Users to Excel 1 June 11th 09 09:44 AM
USING A GOTO COMMAND IN EXCEL gscar2005 Excel Worksheet Functions 1 February 9th 05 05:30 AM
Goto Command in Code JimPNicholls Excel Programming 2 September 1st 04 12:38 PM
search or goto command needed. mightymax Excel Programming 1 July 26th 04 03:42 AM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"