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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"igorek" <(E-Mail Removed)> wrote in message news:A2A48FA4-B4AF-4876-AC67-(E-Mail Removed)...
| 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
|
|

On Dec 14, 10:51 am, igorek <igo...@discussions.microsoft.com> wrote:
> 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