| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change active sheet
Hi,
How can i change the active sheet ? thanks a lot, Maileen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change active sheet
Hi
you could use worksheets("sheet2").activate but why are you trying to do this? -- Regards Frank Kabel Frankfurt, Germany "Maileen" schrieb im Newsbeitrag ... Hi, How can i change the active sheet ? thanks a lot, Maileen |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change active sheet
sheets("Sheet2").select
Assuming you have a sheet2 "Maileen" wrote: Hi, How can i change the active sheet ? thanks a lot, Maileen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet and make new sheet active | 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) | |||
| How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) | |||
| How to make a sheet the active sheet? | Excel Programming | |||
Linear Mode
