Column Name Excel

by [Pieter] (1 Submission)
Category: Microsoft Office Apps/VBA
Difficulty: Intermediate
Date Added: Wed 3^rd February 2021
Rating: (3 Votes)

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

Inputs
Number of the column
Code Returns
Name of the column

Rate Column Name Excel

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

Column Name Excel Comments

No comments have been posted about Column Name Excel. Why not be the first to post a comment about Column Name Excel.