View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default Macro to Go to Sheet

When i have written Macro's to take you to another sheet, I always write

ActiveSheet.Next.Select

However I am getting too many sheets. Is there an easier way to write a
macro to take you directly to another sheet without having to write the above
statement 15 times?