Want to get exact decimal value.
 

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!!!

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

Want to get exact decimal value.
 

Oh!!!

Now i realise my mistake i had declared para_code() as integer. I can
now fix it.

Thanks a lot Mr. Peterson.
__________________________________________________ _______________________

Dave Peterson wrote:

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