View Single Post
  #1   Report Post  
Shooter
 
Posts: n/a
Default naming worksheets

My workbook has 200 worksheets named with the default names ie: worksheet1,
worksheet2...worksheet200. I would like to rename all worksheets with just
the consecutive number ie: 1,2,3...200. Is there a method to do this quickly
or do I need to go in and rename each one individually. Thanks.
--
Shooter