Re: Return Sheet Name?

Nick

Copy/paste this UDF to a general module in your workbook.

Function shtname()
Application.Volatile
shtname = Application.Caller.Parent.Name
End Function

In any cell enter =shtname()

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Tue, 8 Jul 2003 09:40:14 -0400, "Nick Fuller @ BFA" <nfuller@bfa-eng.com>
wrote:

>Is there a way to return a sheetname in a cell?
>
>i.e ='sheetname'
>
>any help would be greatly appreciated.
>