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)
lieuwer
Posted by kristel on November 26, 2001 1:15 AM
ActiveCell.Column
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)
Lieuwe
