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? 3
Dump ListBox Contents to Sheet & Stay on Active Sheet 0
Stay on Active Sheet 2
VBA word change keys 0
VBA Coding Help for Beginner 0
How to create macro to change value in CSV. 0
Find the correct sheet then find a value on that sheet 8

Top