ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Referring to a column (https://www.excelbanter.com/excel-programming/324301-referring-column.html)

Mike D.

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.

Bob Phillips[_6_]

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