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. |