I have an User-Defined Function, called MyUDF().
If I put this function into my worksheet, but just write =myudf(), the function name doesn't show as 'MyUDF()' which the function is named in my VBA code.
What worse is, that if I now delete my formula in the worksheet, or use it somewhere else, and then write it correctly as =MyUDF(), it is as if Excel 'remember' that I previously used it wrong and change it automaticall by itself to =myudf().
Why?!?
How do I "reset" the cached function name, so it shows as in the VBA code?
Bookmarks