Missing decimals in named range when getting the value in vba

Asked Jun 09 '17 at 17:11

Active Jun 09 '17 at 17:11

Viewed 32 times

I have unexpected truncation in a named range in Excel when accessing the value in VBA.

I have a cell called "temp"

When the 'temp' cell has -$0.00002 the following VBA code returns "0".

When the 'temp' cell has -$0.02 the following VBA code returns "-0.02".

MsgBox (Range("temp").Value)

Why is VBA not getting the right value in the first case? How can I fix this?

Thank you

asked Jun 09 '17 at 17:11

user2946746

1

Use `Range("temp").Value2` See [Value v Value2](https://stackoverflow.com/questions/17359835/what-is-the-difference-between-text-value-and-value2) for more. – Scott Holtzman Jun 09 '17 at 17:16
Thanks that was what I totally needed. :) – user2946746 Jun 09 '17 at 17:25

0 Answers0