Want to get exact decimal value.
How did you declare para_code()?
As Double or as Long?
Alwyn wrote:
Hi,
I'm writing a macro to expedite my project work. I need little help
from you.
I'm using a multidimensional array to capture data from excel spread
sheet. The fields hold values in decimal, i.e. 33.5462 and so.
Now my concern is that when I run the following code - para_code(v_i,
h_i) = Val(ActiveCell.Value) I get an whole value, i.e. 34 instead of
33.5462.
Please let me know how to transmit the value as it is.
Thanks a lot in advance!!!
--
Dave Peterson
|