| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column label based on column index
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column label based on column index
=LEFT(ADDRESS(1,A1,4),LEN(ADDRESS(1,A1,4))-1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "igorek" wrote in message ... | 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 | | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column label based on column index
On Dec 14, 10:51 am, igorek 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming cells in a table based on column and row label | Excel Discussion (Misc queries) | |||
| lookup column label based on data in cell | Excel Worksheet Functions | |||
| Select a column based on a index | Excel Programming | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
Linear Mode
