SHEET TAB NAME = A CELL

brumby

Active Member
Joined
Apr 1, 2003
Messages
398
Hiya is it possible to autoname a WORKSHEET TAB, from a selected Cell within the sheet?


Many Thanks,
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
...with macros.

Code:
ActiveSheet.Name = [a1]

Will rename the active sheet to whatever A1's value is.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,284
Messages
5,571,304
Members
412,380
Latest member
Angelagrace
Top