Grüezi Keith

Keith schrieb am 17.03.2005

Is there a Excel VB function that can take a column number and convert it to
a column letter? I can write one on my own, but I hope that there is a built
in function to do this. Some properties will only use column letters and
this presents a problem.

Try the following function:

Public Function ColLetter(bytColNum As Byte) As String
ColLetter = Replace(Cells(1, bytColNum).Address(0, 0), "1", "")
End Function



Mit freundlichen Grüssen
Thomas Ramel

--
- MVP für Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]