<-- Previous || Up || Next -->

Excel Column Number To Letters Function
String Extras Class

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

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

Examples: 
    ExcelColumnNumberToLetters(1) = "A"
    ExcelColumnNumberToLetters(26) = "Z"
    ExcelColumnNumberToLetters(27) = "AA"
See also: 
    NumberToBaseX Function
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.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.