Where is User Defined FUnction

  • Thread starter Thread starter KIM W
  • Start date Start date
K

KIM W

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.
 
udf's are in standard module. in vba, control-f to bring up the find dialog,
select current project and search for wsname
 
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.
 
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.
 
Back
Top