Tom’s Tutorials for Excel: 3 methods to display sheet tab name in a cell
“How do you display a sheet tab name in a cell?” is one of the questions Tom Urtis is most frequently asked.
Here you have 3 useful answers
Method 1 – by formula, workbook must be named (saved at least once).
Method 2 – by UDF (workbook does not need to be named):
Function SheetName() As String
SheetName = ActiveSheet.Name
UDF formula entry:
Method 3 – Macro (workbook does not need to be named)
ActiveCell.Value = ActiveSheet.Name