Return Tab Name

  • Thread starter Thread starter oldblindpew
  • Start date Start date
O

oldblindpew

I haven't been able to find a function that returns the name of a worksheet
tab. In custom headers, the tab is referenced by &[TAB] but this doesn't
work as a cell formula. Is there any way to do it?
Thanks,
 
Try this


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


Note that the workbook needs to be saved and don't replace filename with the
name of the file, it is part of this function

--


Regards,


Peo Sjoblom
 
Try this:

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

The file must have been saved at least once for that to work.
 
i think You you can use this UDF
Function SheetName()
SheetName = Application.Caller.Parent.Name
End Function
 
Back
Top