How to change to active sheet on macro?
 

Does anyone have any suggestions on how to modify following coding? which
work on active sheet rather than specific sheet ("ABC").
Application.Goto Sheets("ABC").Range("I45"), scroll:=True
Thanks in advance for any suggestions
Eric

How to change to active sheet on macro?
 

Application.Goto activesheet.Range("I45"), scroll:=True

Eric wrote:

Does anyone have any suggestions on how to modify following coding? which
work on active sheet rather than specific sheet ("ABC").
Application.Goto Sheets("ABC").Range("I45"), scroll:=True
Thanks in advance for any suggestions
Eric

--

Dave Peterson

How to change to active sheet on macro?
 

If you're already in the active sheet...
Range("I45").select
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Eric" wrote:

Does anyone have any suggestions on how to modify following coding? which
work on active sheet rather than specific sheet ("ABC").
Application.Goto Sheets("ABC").Range("I45"), scroll:=True
Thanks in advance for any suggestions
Eric