Maniuplating Worksheet Tabs

[Joe]

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

Thanks!!

 

[Guest]

Here is one way

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,225)

 

[Guest]

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

 

[Joe]

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

Thanks again!!