• Home
 · 
• Microsoft Office Apps/VBA
 · 
• Column Name Excel

Column Name Excel

Returns the name of the column, given a number.
Eg. 5 -> 'E', 50 -> 'AX'. One line of code!

Inputs
Number of the column

Returns
Name of the column

Rate Column Name Excel

• 1
• 2
• 3
• 4
• 5

(4(4 Vote))

Function ReturnName(ByVal num As Integer) As String
 ReturnName = Split(Cells(, num).Address, "$")(1)
End Function