Problem with reading excel cell value to a VARIANT

Question

hi,

I'm reading a excel cell value to a VARIANT data type from VBA code. When I enter a integer value to the cell, the VARIANT always takes the argument as type double. Please help me to rectify this problem.

Thank you

Answer 1

Excel Cells do not have an integer type: Excel numbers are always doubles. So there is no way of getting an integer/long variant subtype except by doing an implicit or explicit conversion.