Thread: rename tabs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
May May is offline
external usenet poster
 
Posts: 15
Default rename tabs

hi,

I have a spreadsheet containing 30 tabs--named according to the date such as
01.02.07, 02.02.07....28.02.07. However, it will be painful to manualy change
the name of them into 01.03.07, 02.03.07 for the next month. Is there an easy
way to do it by using VBA?

Thanks for any help in advance.