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

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 !!!