Sub Deg2Hex(x As Double, y As Double, grid As String) As String
Dim hexra, hexde As String
x = Round(x * 46603.378)
y = Round(y * 46603.378)
If y < 0 Then y = 16777216 + y
hexra = Bit.ToHexString(x) & "00000000"
hexra = hexra.SubString2(0,8).ToUpperCase
hexde = Bit.ToHexString(y) & "00000000"
hexde = hexde.SubString2(0,8).ToUpperCase
Select grid
Case "eqt"
Return "r" & hexra & "," & hexde
Case "azm"
Return "b" & hexra & "," & hexde
End Select
End Sub