Convert a number to a letter?

Hello folks,

Please refer to the following lines of code:

Dim LetterDecoded As String
Dim CapExp_Count as Integer

CapExp_Count = 10
LetterDecoded = ColumnLetter(CapExp_Count)

In the code above I would like that when:

CapExp_Count = 1, LetterDecoded = "A"
CapExp_Count = 2, LetterDecoded = "B"
CapExp_Count = 3, LetterDecoded = "C"
...
CapExp_Count = 10, LetterDecoded = "J"

etc...

The above sample does not work. Does anyone know why the above sample wouldn't work as this is a sample I found claiming it would work???

All help appreciated!

rn