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

Thanks!!

Here is one way

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,225)
--
Mike Q.


"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!!

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!!

Thanks very much to both posters, the first poster helped do the job for
me.

Thanks again!!

?B?Sm9obi5HcmVlbmFu?=
wrote in :

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

Create a standard module and add this function