View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harshad[_2_] Harshad[_2_] is offline
external usenet poster
 
Posts: 44
Default Rename of sheets by macro

i have Sheet1 to Sheet 55 in my workbook.

I want Sheet1 rename as Main, sheet2 as Content, sheet3 as Micro, sheet4 as
Help, sheet5 as NN1, sheet6 to sheet55 as NN2 to NN50.

Sugest macro.

Thanks