Function to convert column number to letter?

excel vba excel-udf
mezamorphic picture mezamorphic · Oct 9, 2012 · Viewed 420.5k times · Source

Does anyone have an Excel VBA function which can return the column letter(s) from a number?

For example, entering 100 should return CV.

Answer

brettdj picture brettdj · Oct 9, 2012

This function returns the column letter for a given column number.

Function Col_Letter(lngCol As Long) As String
    Dim vArr
    vArr = Split(Cells(1, lngCol).Address(True, False), "$")
    Col_Letter = vArr(0)
End Function

testing code for column 100

Sub Test()
    MsgBox Col_Letter(100)
End Sub

Related questions

function to convert String to upper case

I have been trying to make a user defined function I wrote return it's value in all upper case, using the String.ToUpper() method in VBA. When I try to use my UDF in excel, I get a compiler error …

Read More
Formula to eliminate all but alpha characters

I need to scrub a column of names in Excel to eliminate all non-Alpha characters including periods, commas, spaces, hyphens and apostrophes. EXAMPLE: Change O'Malley-Smith, Tom, Jr. to OMALLEYSMITHTOMJR The client requires this to be an Excel function, otherwise I'd …

Read More
What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?

I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a sheet that includes this formula I get the following error: Microsoft Office Excel is waiting for another application to complete …

Read More