Column Name from Column Number in Excel 1

[rick360]

In Excel-2000, I need to get, in VBA, the column name from the column number (example: column #28 is column "AB". This seems like this should be simple, yet I can't find it anywhere(excel help or searching here). I know there has to be a simpler way than writing a function to do this.

Thanks,
Rick

 

[PHV]

Something like this ?
Left(Cells(,28).Address(True,False), InStr(Cells(,28).Address(True,False),"$")-1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Another way:
Split(Columns(28).Address(False,False),":")(0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

Lots of ways to skin a cat...

MsgBox Split(Cells(, 28).Address(True, False), "$")(0)

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]

 

[rick360]

That works, however it wasn't quite as simple as I had thought. Thanks a bunch, I'd have never figured that out. Have a star for your very quick and effective help.

Rick

 

[bravos1]

the simplest solution is probably

Column_Name = Chr$(28 + 64)

Bravos1

 

[PHV]

Bravos1, Chr$(28 + 64) is [highlight]\[/highlight] ...