Renaming Worksheets using VBA

**ramakavin** · 12-23-2008, 07:28 AM

Hello Guys,

Here is my problem. I have 90 sheets in my workbook, each named CHHeb1, Chheb2 .. CHheb90.

I need to rename them for ex, CHHeb1 to CHQuo1, CHHeb2 to ChQuo2...CHHeb90 to ChQuo90..

Could u please help me achieve this with a macro please?

thanks a lot in advance

**StephenR** · 12-23-2008, 07:42 AM

Perhaps like so:

Please Login or Register  to view this content.

**davesexcel** · 12-23-2008, 08:17 AM

Create a sheet, Name it
TOC
then run this code

Please Login or Register  to view this content.

This creates a TOC in column A
In column B enter the new sheet names you want for each olds sheet name
then run this code

Please Login or Register  to view this content.

This will replace each sheet name in column A with the new sheet name in column B.

Renaming Worksheets using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Renaming Worksheets using VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions