PDS,
This formula gets your sheet name in cell A1:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Syed
--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread:
http://www.excelforum.com/showthread...hreadid=539416