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