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