As you may recall, I’ve written about registering User Defined Functions before.
The problem with the trick I used in that post, was (and this isn’t trivial): it crashed Excel.
KeepITCool came up with yet another trick to make this work, which I have described in
Jan Karel Pieterse
JKP Application Development Services