You can get the name of a sheet with a user defined function

Create a standard module and add this function

Function SheetName() As Variant
SheetName = Application.Caller.Worksheet.Name
End Function


in a cell in the sheet you are interested in type in the formula =sheetname()
and it will return the name of the sheet.

Is that what you are looking for???

--
www.alignment-systems.com


"Joe" wrote:

I have a formula that is trying to take for example the word "Hello" from a
worksheet tab. Is that even possible?

Thanks!!