Rob,
Its Great.
Thank you for your patiance and taking me out of a major problem.
However there is a small problem.

If I use your code as it is the result is nothing.
If I replace If Err.Number < 0 to If Err.Number = 0 I get the prope
result.
Can you pl explain this or am I doing somthing wrong?

Secondly, How to use the same trick for the formula functions havin
morethen one arguments? I have got a function which takes 4 arguments
I am planning to use your solution for all my custom formul
functions.

With regards,
Malcom

--
Malcom Jaz
-----------------------------------------------------------------------
Malcom Jazz's Profile: http://www.excelforum.com/member.php...fo&userid=1587
View this thread: http://www.excelforum.com/showthread.php?threadid=27360