How do I use functions that I have written in Excel formulas

[Gita_B]

I have functions that I have written. i should have been able to use them in
EXcel formula but when i Use the function in the excel Sheet it is not
recognized. I get #Name Error.

Can some one help?

Regards
Gita.

 

[Mike H]

Hi,

Assuming you mean UDF's then you will get a NAME error if you put them in
the wrong place. Try this

ALT+F11 to open VB editor. Right click 'ThisWorkbook' and insert module and
put your function there.

Mike

 

[Gord Dibben]

Are the functions in a general module in the workbook in which you are
calling them?

Should be OK in that case.

If stored in another workbook like Personal.xls you must preface the formula
as such................

=Personal.xls!myfunction(args)


Gord Dibben MS Excel MVP