Prev: AUTOMATIC EMAIL
Next: Working in Sheet2 with data from Sheet1
From: Eric on 1 Jun 2010 12:06
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
From: Dave Peterson on 1 Jun 2010 12:53
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
From: Gary Brown on 1 Jun 2010 13:26
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
 | 
Pages: 1
Prev: AUTOMATIC EMAIL
Next: Working in Sheet2 with data from Sheet1