Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a column
Hi. Using the RANGE statement, is there a way to refer to a particular
column number instead of the column letter? For instance, RANGE("C4") points to the third column and fourth row. In my application, I may not know the column letter but I will know the column number (stored in a variable - "k"). Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a column
Cells(row_num, column_num)
-- HTH RP (remove nothere from the email address if mailing direct) "Mike D." wrote in message ... Hi. Using the RANGE statement, is there a way to refer to a particular column number instead of the column letter? For instance, RANGE("C4") points to the third column and fourth row. In my application, I may not know the column letter but I will know the column number (stored in a variable - "k"). Thanks, Mike. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to a portion of a column | Excel Discussion (Misc queries) | |||
Referring to a list in one sheet to another column on a different | Excel Discussion (Misc queries) | |||
Referring to a column | Excel Discussion (Misc queries) | |||
Referring to a Range using Cells(Row,Column) system | Excel Programming | |||
Referring to a column | Excel Programming |