working on it ...


Explore Public Snippets

Sort by

Found 1 snippet matching: "excel column letters vba __function"

    public by fabio.nosenzo  3188  3  6  2

    Get column letter Excel VBA

    Given the column number, this function returns the letter(s) corrisponding to the excel column. Thanks to brettdj
    Function Col_Letter(lngCol As Long) As String
    Dim vArr
    vArr = Split(Cells(1, lngCol).Address(True, False), "$")
    Col_Letter = vArr(0)
    End Function
    'test the code
    Sub Test()
    MsgBox Col_Letter(100)
    End Sub            

    List Complete ( 1 snippet total )

    Cannot find what you were looking for?
    Ask the Snip2Code Community

    • Public Snippets
    • Channels Snippets