Set Cell Equal to Another Cell in VBA without Rounding

[billbilliamson]

Hello,

I am using the following code:

Sheets("Sheet1").Range("A1").Value = Sheets("Sheet2").Range("A2").Value

However, if "A1" is a value to 3 decimal places, the code is rounding it to 2 decimals. For example, if "A1" is $0.437, after the code executes, "A2" on "Sheet2" is $0.44

I used Message Boxes, and it definitely rounded to two decimal places, I'm just not sure why...

MsgBox Sheets("Sheet1").Range("A1").Value

MsgBox Sheets("Sheet2").Range("A2").Value

Any help?

 

[billbilliamson]

I think I figured it out - apparently there is a ".Value2" property that allows for more decimal places.

When I converted my code to use .Value2, the rounding stopped. Hopefully, someone else will find this helpful.

Thanks!