variant and currency decimals

[Guest]

I am using a variant variable to store the values of calculated cells and
then transfer that value to another cell. The values can be text,
percentages, or currency.

I need the four decimal places of the currency values. In the debug window,
when the variant subtype is currency, the four decimal places are present.
When the variant gets transferred to the worksheet, the currency value gets
rounded down to only two decimal places. The cell formatting of the source
and destination cells is exactly the same (currency, four decimals).

Can anyone explain what is happening? I'm using Excel 2000.

Thanks.
Mary

 

[Tom Ogilvy]

try using the value2 property instead of value.

v = activecell.Value2

 

[Guest]

Awesome! I didn't even know there was a value2 property. Now I can have all
the decimal places that I want.

Thanks, Tom.

Mary