MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column letter instead of number

Posted by Lieuwer on November 25, 2001 9:31 PM

Is there a code that would give the column letter(s) instead of the column number of the active cell.

I use now the following code but are not satisfied with it and it is limited to the first 16 columns.

Dim theLetter As String
theLetter = Mid(ActiveCell.Address, 2, 1)


Posted by kristel on November 26, 2001 1:15 AM


Posted by Ivan F Moala on November 26, 2001 1:26 AM

theletter = ActiveCell.Address(xlA1)

Posted by Lieuwer on November 26, 2001 5:52 PM

Both don't work !

Both option given above don't work. Option one gives the column number instead of the letter and option two gives the same result as ActiveCell.address

I only want to have the letter(s)