Worksheet Properties

[Guest]

How can I display the Tab or File name into a cell

 

[Bob Phillips]

To get the tab name

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

File name

=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Harald Staff]

Hi

=CELL("filename",A1)

Extract the sheet name from there. Note that the file must be saved for this
to work.