You're going to let the users update your UDF???

That sounds more confusing than learning about the immediate window.

cappy2112 wrote:

or even just show the immediate window in the VBE (ctrl-g).
The people using the spreadsheet won't know how to use the Immediate
Window, and it would be confusing for them.

Then type this and hit enter:
application.calculatefull

I will just update the version string and manually do the Shift-Alt-
Ctrl-F9 whenever I make code changes, before distributing the new
version.

(well, if .calculatefull is in the version of excel that you're using--I've lost
track what you're running.)

2003

--

Dave Peterson