what's the function to return a sheetname in a cell in Excel?
 

I was hoping it was this, and it ain't.

=sheetname()

or

=sheet()

what's the function to return a sheetname in a cell in Excel?
 

The workbook has to be saved first.

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

you can put that anywhere, even in A1

--


Regards,


Peo Sjoblom

"judi" wrote in message
...
I was hoping it was this, and it ain't.

=sheetname()

or

=sheet()

what's the function to return a sheetname in a cell in Excel?
 

Thank you. I realize now that I am not the first to ask this question. I
appreciate your speedy answer. I will share with my colleagues. Cheers!

"Peo Sjoblom" wrote:

The workbook has to be saved first.

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

you can put that anywhere, even in A1

--


Regards,


Peo Sjoblom

"judi" wrote in message
...
I was hoping it was this, and it ain't.

=sheetname()

or

=sheet()

what's the function to return a sheetname in a cell in Excel?
 

It could be if you had a UDF

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

=SheetName()

The workbook does not have be saved first.

But the native function Peo posted works a little faster and who would want
to know the sheetname in an unsaved file?


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 15:14:03 -0700, judi
wrote:

I was hoping it was this, and it ain't.

=sheetname()

or

=sheet()