Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a sheet the active sheet?
If the user is on sheet 3, and I want the macro to be applied to sheet
2, how can I get the macro to make sheet 2 the active sheet? tia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a sheet the active sheet?
worksheets("sheet2").Activate
or Application.Goto Reference:=Worksheets("Sheet2").Range("A1") or you can just refer to Sheet2 and not make it the active sheet With Worksheets("Sheet2") .Range("A1").Value = 7 .Range("A1:A10").Interior.ColorIndex = 5 End with as an example. -- Regards, Tom Ogilvy wrote in message ... If the user is on sheet 3, and I want the macro to be applied to sheet 2, how can I get the macro to make sheet 2 the active sheet? tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) |