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