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

First question... I think I made a mistake. You corrected it.

Second...
eg.
Selection.Formula = "=MyFunction(" & rngFirst.Address & ", " &
rngSecond.Address & ", " & rngThird.Address & ", " & rngFourth.Address & ")"



--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Malcom Jazz" wrote in message
...

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 proper
result.
Can you pl explain this or am I doing somthing wrong?

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

With regards,
Malcom.


--
Malcom Jazz
------------------------------------------------------------------------
Malcom Jazz's Profile:
http://www.excelforum.com/member.php...o&userid=15872
View this thread: http://www.excelforum.com/showthread...hreadid=273601