=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

--
HTH

Bob Phillips

"Rustynail" wrote in message
...
When i rename a worksheet i want the name to populate in preselected cell
with in the worksheet. is this possible?