Can anyone say something about this behaviour in VB:
Hex(65535) = "FFFF" but &HFFFF = -1
Code:
Option Explicit

Sub Test()
   Dim lngX As Long
   Dim lngY As Long
   
   lngX = 65535
   lngY = &HFFFF
   
   Debug.Print lngX, Hex(lngX)
   Debug.Print lngY, Hex(lngY)
End Sub
------------------------------
 65535        FFFF
-1            FFFFFFFF