Excel - Return column alphabet from column number

[Sathyaish]

Is there some function in Excel (VBA) that will get me the column alphabet if I provide the column number, or do I have to write one. I ask because I know that there is, yet I recall I wrote this functionality for the previous application, and I don't want to:

(1) Reuse it, if there's something in-built
(2) Re-invent the wheel

Help!

PS: I'm looking for something like:

Function GetAlphabet(ByVal ColumnNumber as Long) as String

which if I call must say:

GetAlphabet(1)

Output: "A"

[si_the_geek]

No built-in function as far as I know, but here's a function I wrote:

Function xl_Col(ByRef Col_No) As String
'returns Excel column name from value
'(eg: col_no 27 returns "AA")
                                       'Only allow valid columns
  If Col_No < 1 Or Col_No > 256 Then Exit Function
 
  If Col_No < 27 Then                  'Single letter
    xl_Col = Chr(Col_No + 64)
  Else                                 'Two letters
    xl_Col = Chr(Int((Col_No - 1) / 26) + 64) & _
             Chr(((Col_No - 1) Mod 26) + 1 + 64)
  End If
 
End Function

[Sathyaish]

Thank you so much.

[nnebeel]

Another way:
If you only need to return the letter number of columns A-Z in an Excel 2003 Spreadsheet:
Use the CHAR() function:

=char(64+column())

Let me know if this helps

[westconn1]

columns(1).address will return $A:$A