Well, I want to achieve that right from my VBA. MyFunc returns double
and where the dates are in future it returns 0.0. I know I am asking to
return double and string from the same function based on the date given.
Ideally I want to retain my result column to be number formatted and
preferably do not want it to be populated with string (numerical data
displayed as string).


--
nougain
------------------------------------------------------------------------
nougain's Profile: http://www.excelforum.com/member.php...o&userid=32031
View this thread: http://www.excelforum.com/showthread...hreadid=547410