=sheettab

[ForSale]

is it possible to have a cell reference the name of the sheet tab? fo
instance, ="Number of audits for "& sheettab i'm on excel 2002 SP3, X
pro.
thank

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[Gord Dibben]

Using Excel's built-in functions.......

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

will return just the sheet name.

A UDF would be much neater and less typing.

Function SheetName(Optional ByVal rng As Range) As String
Application.Volatile
If rng Is Nothing Then Set rng = Application.Caller
SheetName = rng.Parent.Name
End Function

Usage is: ="Number of audits for " & SheetName()

Gord Dibben Excel MVP