Where is User Defined FUnction

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.
 
G

Gary Keramidas

udf's are in standard module. in vba, control-f to bring up the find dialog,
select current project and search for wsname
 
D

Dave Peterson

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.
 
K

KIM W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top