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

  • Comment on Re^2: Excel OLE cell value custome pre-defined predefined function formula error