please post the code


"vga1976" wrote in message
...

I have a function that wrote the result on a Range using its property
Value. The function works fine when I test it in VBA, I mean the result
is wrote correctly on the range. But the function fails when I used it
on the worksheet as a cell's formula, it fails at the line when I
assign the result to the range using its property Value.

Could you help me to fix this problem?

Regards


--
vga1976
------------------------------------------------------------------------
vga1976's Profile: http://www.officehelp.in/member.php?userid=5683
View this thread: http://www.officehelp.in/showthread.php?t=1310532

Posted from - http://www.officehelp.in