I have a number of say 3. I turn it into an integer, and hey voila!, I have a 2.

Sounds familiar? Then please share.


Excel macro puts a number into a field. It adds 0.4 every time.

Range("Variables!G" & y) = Range("Variables!G" & y) + Range("Variables!B9")

B9 = 0.4
It starts off with 1



Then that number is placed into another field as an integer.

Range("F" & y) = Int(Range("Variables!G" & y).Value)

All works well till the source number is a whole number.
2.4 gives me 2 etc.

But if its a, say, 3 then it returns a fuckin 2.

Makes no difference if range G is formatted as numbers or general.

However, if I manually type a 3 into the range G field, it returns a 3

Source is not 2.99999 or anything



WTF??


Any ideas?