Creating Custom Function in Add-in

[JT21]

Hi,


I have copied a custom function into a VBA Add-in. The code runs something like this:

"Function xxyyzz(r As Range) As String

Application.Volatile

Code xxxxxx

End Function"

I have unable to access the function the way I access the normal worksheet functions. I have checked and confirmed that the function is listed in my Insert Function list. However, when I paste and try to use it from the list, an error message "Name?"appears.

I have tried various ways but wihtout success. I am a VBA newbie. Would appreciate some help.

 

[magbo]

Hi, check security level applied to your Excel - if macros are disabled, UDF does not work:

http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx