getting column name given column number

Essam

New Member
Joined
Jul 29, 2002
Messages
16
Is there any built in function in Excel VBA to get the column name given the column number, ie column 63 is "BK" so I need something like

colnam=getcol(63)

and should return "BK" in colnam

Thanks
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

ReportsTeam

New Member
Joined
Jul 28, 2002
Messages
31
Couldn't find a built in function - had to create a User Fuction for this.

'======================================
Function GetCol(ColumnNumber)

FuncRange = Cells(1, ColumnNumber).AddressLocal(False, False)
'Creates Range (defaults Row to 1) and retuns Range in xlA1 format

FuncColLength = Len(FuncRange)
'finds length of range reference

GetCol = Left(FuncRange, FuncColLength - 1)
'row always "1" therefore take 1 away from string length and you are left with column ref

End Function
'======================================

In a separate Module

Colname = GetCol(63)

Will return Colname as 'BK'
 

Watch MrExcel Video

Forum statistics

Threads
1,099,650
Messages
5,469,943
Members
406,674
Latest member
MrSTruct

This Week's Hot Topics

Top