in reply to Re: Excel OLE cell value custome pre-defined predefined function formula error
in thread Excel OLE cell value custome pre-defined predefined function formula error
There is usually no difference between Value and Value2, and if you are getting an error value, I have never encountered a difference. The difference comes with dates, where Value will return 01/01/2001 while Value2 will return 36892. I believe there are some other esoteric situations where there is a difference, but I have never needed to know them.
Regards,
John Davies
|
|---|