I really should be using pseudoname for my posts here! I overlooked the
absence of parentheses, and therefore missed that it could be a named formula
(which it was.)
BTW, here is what it was, returning name of worksheet:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)

Thanks.

"Dave Peterson" wrote:

If you really type in: =wsname
and not =wsname() (with the ()'s), then it's not a UDF.

Look in the name manager for a defined name.



KIM W wrote:

I obtained an Excel 2007 Workbook that has a User Defined FUnction in it, but
I cannot locate the code for it. I am faily sure it is a UDF, and it works
properly. (It is called WSName and it displays worksheet name in a cell by
typing in =WSName.)
How can I find the code behind the UDF? I have searched around in various
modules to no avail.

--

Dave Peterson