A AlexN New Member Joined Apr 8, 2002 Messages 7 Nov 22, 2005 #1 Hi, is it possible to put a simple formula in a cell to show the name of a worksheet. Thanks for your help Alex
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 Nov 22, 2005 #2 =RIGHT(CELL("FILENAME"),LEN(CELL("FILENAME"))-FIND("]",CELL("FILENAME")))
Barrie Davidson MrExcel MVP Joined Feb 10, 2002 Messages 2,330 Nov 22, 2005 #3 Note that this will not work on a new file that has not been saved.
L Legacy 51064 Guest Nov 22, 2005 #5 ADVERTISEMENT Good point Barrie! If you have mutliple sheets open, then the value will change as well.
ADVERTISEMENT Good point Barrie! If you have mutliple sheets open, then the value will change as well.
A AlexN New Member Joined Apr 8, 2002 Messages 7 Nov 22, 2005 #6 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!
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 Nov 22, 2005 #7 You can get around that by slightly changing the formula to: =RIGHT(CELL("FILENAME",A1),LEN(CELL("FILENAME",A1))-FIND("]",CELL("FILENAME",A1))) Regards,
You can get around that by slightly changing the formula to: =RIGHT(CELL("FILENAME",A1),LEN(CELL("FILENAME",A1))-FIND("]",CELL("FILENAME",A1))) Regards,