Function String Extras Class

ExcelColumnNumberToLetters

Converts numbers into Excel column names. Converts 1 to "A", 26 to "Z", 27 to "AA", etc.

Signature (Visual Basic / VBA)

Public Function ExcelColumnNumberToLetters( _
    ByVal vColumnNumber As Variant _
    ) As Variant

Code Example

    ExcelColumnNumberToLetters(1) = "A"
    ExcelColumnNumberToLetters(26) = "Z"
    ExcelColumnNumberToLetters(27) = "AA"

Parameters

Parameter Description
vColumnNumber Number of the column whose alphabetic name is to be returned. Function returns Null if vColumnNumber is Null or cannot be fixed up to a number. Function returns Null if vColumnNumber is not within the range from 1 to 256 inclusive.