How to change to active sheet on macro?

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for active sheet only	Victor Delta	Microsoft Excel Misc	4	21st Oct 2009 08:37 PM
Get macro to run on all sheets not just the active sheet	trey1982	Microsoft Excel Programming	2	7th Apr 2009 01:44 PM
macro active sheet	liem	Microsoft Excel Misc	1	18th Jan 2008 05:48 AM
ow can I get the active sheet name to a var in a macro??	=?Utf-8?B?aXRhbG8=?=	Microsoft Excel Programming	1	16th May 2006 10:36 PM
How to change macro so it performs actions on ACTIVE sheet?	=?Utf-8?B?VG9tOTI4Mw==?=	Microsoft Excel Misc	6	15th Apr 2005 07:32 AM