Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting sheets without specifying
i'm adding a hyperlink to a cell in vba, and i need it to link to th
the worksheet, which at the time, will be directly after the activ worksheet... can i do this without specifying sheet names? Thanks : -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting sheets without specifying
Yes
You need to get your code to return the index number of the active sheet - and then select the next one Something like.. Sheets(ActiveSheet.Index + 1).Selec You'll need to wrap some check stuff around it - to make sure that there IS a sheet after the active sheet before it tries to select it !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting sheets - II | Excel Discussion (Misc queries) | |||
Selecting sheets | Excel Discussion (Misc queries) | |||
selecting sheets in vb | Excel Programming | |||
selecting sheets | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming |