How to change to active sheet on macro?

E

Eric

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to move worksheet into specific position? 3
How to code it in macro? 1
Run macro from active workbook whose name keeps changing 20
Stay on Active Sheet 2
Sheet Selection 2
How to delete sheets using macro? 13
How to code macro with condition? 4
Return To Last Active Sheet 4

Top