Excel - How to change to active sheet on macro?

Asked By Eric on 01-Jun-10 12:06 PM
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 replied to Eric on 01-Jun-10 12:53 PM
Application.Goto activesheet.Range("I45"), scroll:=True


--

Dave Peterson
Gary Brown replied to Eric on 01-Jun-10 01:26 PM
If you are 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