referencing a sheet name?

[zerosleep]

looking for a formula that will get me the sheet name...
example:
I have 3 sheets each named X, Y, Z
in cells A1 I want the name of sheet 3, which would be X

thanks for the help!

[dominicb]

Good evening zerosleep

I have 3 sheets each named X, Y, Z
in cells A1 I want the name of sheet 3, which would be X

There are ways and means of extracting the sheetname, but only (I think) the activesheet. There is also a drawback that the file must be saved.

Why not use a custome function :

Function SheetName(WhichSheet As Integer)
Application.Volatile
SheetName = Sheets(WhichSheet).Name
End Function

In this instance using the formula :
=SheetName(3)
would return X.

HTH

DominicB

[zerosleep]

Thanks DominicB, works great!! much appreciated!