Ken Johnson wrote:
BorisS wrote:
is there a function that will give me the sheet tab name of a cell or sheet?
--
Boris


Hi Boris

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

puts the tab name into A1. Workbook must be saved before it will work.

Ken Johnson

I shouldn't have said "puts the tab name into A1". Obviously it puts
the tab name into the cell with the formula.
Ken Johnson