That is a really strange thing you've discovered. Must be something to do with the implementation of the compare function that VB uses.
On another front, you might find it easier to do comparisons like this easier if you use the Select statement instead of nested ifs
VB Code:
Select Case aa Case Is < bb MsgBox aa & "<" & bb Case Is = bb MsgBox aa & "=" & bb Case Is > bb MsgBox aa & ">" & bb End Select
Makes it easier to read and debug.
Just thought you might want to know.




Reply With Quote