Getting name of worksheet

Giganews Newsgroups
Subject: Getting name of worksheet
Posted by:  Jack Schitt (mind-the-g…@DEEPblueyonder.co.uk)
Date: Sun, 23 May 2004

=RIGHT(CELL("filename",$A$5),1+LEN(CELL("filename",$A$5))-FIND("[",CELL("fil
ename",$A$5)))

returns "#VALUE!"

when the worksheet name is identical to the workbook name.

Any way around that, so that it returns the worksheet name both when it is
identical and not identical to workbook name?

--
Return email address is not as DEEP as it appears

Replies