Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Pls teach me the correct way to "return activecell's column header in
Alphabet". In VBA: Columns(1) represents column A Columns(2) represents column B Columns(5) represents column E Columns(26) represents column Z When I get VBA to return a variable (an integer) between 1~26, how can I convert this back to alphabet (A~Z)? Currently in my codes, I do like this to display the €śAlphabet€ť of the column header of activecell: 'Msgbox Left(ActiveCell.Address(False, False, xlA1),1) Now, I get into trouble when the returned integer exceeds 26. Thanks a lot. -- Edmund (Using Excel XP) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return column header | Excel Discussion (Misc queries) | |||
How to return a Column Header | Excel Discussion (Misc queries) | |||
Return column number from column header text | Excel Discussion (Misc queries) | |||
Return Column header, if row value is > X | Excel Discussion (Misc queries) | |||
Excel - Return column alphabet from column number | Excel Programming |