How can i get the Column letters of a cell (need to make it work past the Z column such as AA,AB) [duplicate]

Question

Possible Duplicate:
VBA function to convert column number to letter?

I want to have the column letters past the Z column, there are many techniques for getting it before Z column but after Z, nothing seems to work Is there a way to do so?

Answer 1

Another method:

Public Function ColumnLettersFromRange(rInput As Range) As String

    ColumnLettersFromRange = Split(rInput.Address, "$")(1)

End Function