Rename sheet

**sanjith.M.G** · 02-27-2014, 07:25 AM

Hi all,

Please find the attached file I need to rename the below sheet by different name by using Macro.

I have attached Macro file also In SSS.xls it running but in Example not running.

Because sheet name different.can please solve this issue.

Regards,
Sanjith.M.G

**Olly** · 02-27-2014, 08:37 AM

Your code:

Please Login or Register  to view this content.

It works (once) on workbook sssss.xls, as this workbook has worksheets named "TOC" and "Table 1".
It doesn't work on Example.xls (not only because there is no code in Example.xls...) because there are no worksheets named "TOC" and "Table 1" in Example.xls

What are you actually trying to achieve?

**sanjith.M.G** · 06-19-2014, 10:52 AM

Hello Olly,

Thanks for reply,

I want to rename the below sheets like (Sheet 1, sheet 2 and sheet 100) as per the TOC in cell A to be like (Q1,Q2,Q3…..etc).

Regards,
Sanjith