Column label based on column index

[igorek]

Is there a way to get a column label (A, B, ...AA, AB ) based on column
number. Lets say i have a column number 27 thus i want to see AA.

thanks
Ig

 

[Niek Otten]

=LEFT(ADDRESS(1,A1,4),LEN(ADDRESS(1,A1,4))-1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a way to get a column label (A, B, ...AA, AB ) based on column
| number. Lets say i have a column number 27 thus i want to see AA.
|
| thanks
| Ig
|
|

 

[Leith Ross]

Is there a way to get a column label (A, B, ...AA, AB ) based on column
number. Lets say i have a column number 27 thus i want to see AA.

thanks
Ig

Hello lg,

Here is function that takes the column letter and returns the column
number.

Function ColNumber(Column_Letter As String) As Long

ColNumber = ActiveSheet.Cells(1, Column_Letter).Column

End Function


Example:
N = ColNumber("AA")

Sincerely,
Leith Ross