Niklas,

You can use a function like the following:

Function ColLetter(Rng As Range) As String
ColLetter = Left(Rng.Address(False, False), 1 - (Rng.Column
26))
End Function


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Niklas" wrote in message
...
Hi
If I use Range.Column I get numbers, but how do I do if I
want to get the letters?
Regards
/Niklas