Convert Column Number to Excel Column Letters (from Col A to ZZ)
:
Return to List
Private Function ConvertColumnNumberToLetter(ByVal ColumnNumber As Integer)
IntegerResult = ColumnNumber \ 26
FractionalResult = (ColumnNumber / 26) - IntegerResult
Remainder = ColumnNumber Mod 26
If IntegerResult = 0 Then
FirstLetter = ""
ElseIf IntegerResult = 1 And FractionalResult = 0 Then
FirstLetter = ""
ConvertColumnNumberToLetter = "Z"
Exit Function
ElseIf IntegerResult > 1 And FractionalResult = 0 Then
FirstLetter = Chr(64 + (IntegerResult - 1))
ConvertColumnNumberToLetter = FirstLetter & "Z"
Exit Function
Else
FirstLetter = Chr(64 + IntegerResult)
End If
SecondLetter = Chr(64 + Remainder)
ConvertColumnNumberToLetter = FirstLetter & SecondLetter
End Function
See also:
Accessing Particular Cells in Worksheet
Column Number or Letter of selected cell
Convert Column Letter to Number function
Creating and Sizing Cell Comments
Delete Cell Contents without deleting cell
Determining Last Cells (column & row) with Data
Drop-Down Cell Values (restricting User)
Fill Empty Cells of Selected Area with Data Above Cell
Inserting a Formula into the Active Cell
Moving down one cell (changing active cell)
Moving Right 1 Cell
Pasting (previously copied) Cells
Row number of Selected Cell
Selecting ALL the Cells in a Worksheet
Selecting Non-Adjacent Cells in Worksheet
Setting Current Cell's Value
Note to Webmaster