| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change to active sheet on macro?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to change to active sheet on macro?
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to change to active sheet on macro?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change textbox caption in Active sheet from UserForm | Excel Programming | |||
| Change tab colour for active sheet | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) | |||
| change active sheet | Excel Programming | |||
Hybrid Mode
