Formula for Worksheet Name

AlexN

New Member
Joined
Apr 8, 2002
Messages
7
Hi,
is it possible to put a simple formula in a cell to show the name of a worksheet.

Thanks for your help
Alex
 
L

Legacy 51064

Guest
=RIGHT(CELL("FILENAME"),LEN(CELL("FILENAME"))-FIND("]",CELL("FILENAME")))
 
L

Legacy 51064

Guest
Good point Barrie! If you have mutliple sheets open, then the value will change as well.
 

AlexN

New Member
Joined
Apr 8, 2002
Messages
7
Yeah I just noticed that. Am just trying to work that out now as I need this to give me the name for each individual worksheet all in the same file!
 

Barrie Davidson

MrExcel MVP
Joined
Feb 10, 2002
Messages
2,330
You can get around that by slightly changing the formula to:

=RIGHT(CELL("FILENAME",A1),LEN(CELL("FILENAME",A1))-FIND("]",CELL("FILENAME",A1)))

Regards,
 

Forum statistics

Threads
1,078,117
Messages
5,338,311
Members
399,225
Latest member
EMCNEIL

Some videos you may like

This Week's Hot Topics

Top