User Defined Functions

[Ron Bishop]

Is there any way to trap the error of passing the wrong
number of arguments to a user defined function? Built-in
functions trap this error and present the user with an
error dialog. My user defined function simply returns
#VALUE! with no error message. The function is not even
being executed because a STOP as the first line of code
does not drop me into the VBA editor.

I know I could use the OPTIONAL or PARAMARRAY keywords but
I was hoping there might be a cleaner solution.

Thanks