Make a cell show the name of the sheet tab
Thank you it worked perfectly!!
"Biff" wrote:
Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
"LPatt" wrote in message
...
Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
|