View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Grey Newt Grey Newt is offline
external usenet poster
 
Posts: 16
Default 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 !!!