Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mapping columns
Greetings
Is there a way to map column number to alphabet such column 6 equates to "F" and column equates to AA. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mapping columns
Not really sure what you want here but perhaps the following will help. The
first 2 return the column number from the alpha id and the second 2 return the column alpha id from the column number. Returning the Address (alpha id) the parameters indicate whether to return absolute or relative. ,0 is relative and 1 (or no parameter) returns absolute. Sub test() MsgBox Columns("AA").Column MsgBox Columns("F").Column MsgBox Columns(27).Address(, 0) 'Relative MsgBox Columns(6).Address(, 1) 'Absolute MsgBox Columns(6).Address() 'Absolute End Sub -- Regards, OssieMac "Farooq Sheri" wrote: Greetings Is there a way to map column number to alphabet such column 6 equates to "F" and column equates to AA. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mapping columns
I should perhaps have expanded my answer to show you how to extract just the
alpha column id. I have used a variable for the position of the colon to make it self explanatory but you could nest the entire forumla in one line of code. Dim ColonPos As Integer ColonPos = InStr(1, Columns(27).Address(, 0), ":") MsgBox Left(Columns(27).Address(, 0), ColonPos - 1) -- Regards, OssieMac |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
mapping columns
Another way
Dim lngCol As Long lngCol = 27 Msgbox Split(cells(1,lngCol).address,"$")(1) -- Jacob "Farooq Sheri" wrote: Greetings Is there a way to map column number to alphabet such column 6 equates to "F" and column equates to AA. Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
mapping columns
Does this do what you want...
ColumnNumber = 5 ColumnLetter = Split(Cells(1, ColumnNumber).Address(1, 0), "$")(0) -- Rick (MVP - Excel) "Farooq Sheri" wrote in message ... Greetings Is there a way to map column number to alphabet such column 6 equates to "F" and column equates to AA. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mapping? columns from one excel workbook to another | Excel Discussion (Misc queries) | |||
mapping | Excel Discussion (Misc queries) | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
Macro to copy columns from 1st sheet to 2nd according to mapping-p | Excel Programming | |||
Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions |