View Single Post
  #5   Report Post  
John Michl
 
Posts: n/a
Default Worksheet tabs in a Macro

Jim, my method uses the index for the sheet which you cannot change.
Sheet1 always has an index of 1 even when you change the name to
something other than Sheet1.

- John