VBA Routine to return Column Letter of Cell

Associated Files Download Links

The standard Excel “Column” Function returns the number rather than the letter of the column e.g:

Column(E4) – returns the number 5 rather than the letter E
Column(AD12) returns the number 30 rather than AD.

The following function returns the letter rather than the number of the column. So in the above two examples we have the letters E and AD respectively . The routine will return blank if more than a single cell is referenced:

You may also like some of this related content...

The following Subroutine will delete each row in a range where the value in Column
Delete Blank Rows The obvious way to remove blank rows from a data set is
If you ever need to count the number of rows that were selected, use Selection.Rows.Count
Select Every 5th Row Imagine that we have 20,000 rows of data in an Excel
Here is example code to determine the Start and End Column of a Merged Cell.
Ads