View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I use functions that I have written in Excel formulas

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

"Gita_B" wrote:

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.