How to stop unwanted rounding

[Osprey3]

I am using the following code to load a range into a variant, do a simple calculation and then reload the range..

Please Login or Register  to view this content.

The normal values of a and b are around .05 and .02. When I first tried this code the range had not been multiplied. I used the locals window and found that a and b were being stored as 1 not 1.04.
when I increased the value of a and b to 1.55 I found that they were stored as 2. The expected calculation then showed and all the elements were multiplied by 2 not 1.55.
How can I ensure that the numbers are stored in the correct way and then perform properly in the code?
John

[MrShorty]

When I first tried this code the range had not been multiplied. I used the locals window and found that a and b were being stored as 1 not 1.04.

Do you mean Inc and Inc2 here, instead of a and b (which you say typically have values of 0.05 and 0.02)? I note that Inc and Inc2 are both dim'ed as Long. When VBA adds 1+0.02, it will get 1.02. When VBA then tries to store 1.02 in a Long, it will round to the nearest integer. It appears to me that the results you are getting are consistent with the data types you are using.

My guess is that you need to type Inc and Inc2 as Doubles rather than Longs, but that ignores any reasons you have for typing them as Longs. One way or another (whether by changing the type of Inc and Inc2 or introducing new double variables in place of Inc and Inc2), it appears to me that you need to store the 1+a and 1+b results in double variables.

[romperstomper]

Have you declared a and b somewhere as either Integer or Long? If so, declare them as Double.