Public Function IndexToChar(lngColumn As Long) As String
If lngColumn < 1 Or lngColumn > 16384 Then Exit Function
IndexToChar = IndexToChar(Int((lngColumn - 1) / 26)) &
Chr(((lngColumn - 1) Mod 26) + Asc("A"))
End Function
Public Function IndexToChar(lngColumn As Long) As String
If lngColumn < 1 Or lngColumn > 16384 Then Exit Function
IndexToChar = IndexToChar(Int((lngColumn - 1) / 26)) &
Chr(((lngColumn - 1) Mod 26) + Asc("A"))
End Function