Is there a way to make the Int() function in VBA work like the one in Excel? I keep coming across instances where a number that appears to be an integer is rounded down with my VBA code.
Code:
Sub Test()
a = (151.2 * 100)
MsgBox Int(a) 'Returns 15119
MsgBox a 'Returns 15120
MsgBox a = 15120 'Returns False
End Sub