![]() |
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. |
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. |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com