Account Login  Username:  Password: 

Column Name Excel

by [Pieter] (1 Submission)
Category: Microsoft Office Apps/VBA
Difficulty: Intermediate
Date Added: Wed 3rd 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

Download Snippet Download this snippet   Add to My Save List Add to My Saved Code

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.

Post your comment

Subject:
Message:

0/1000 characters