Referring to a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Cells(row_num, column_num)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with a loop and column references 27
Refer to column in range statement 1
best way to express the range "column N to column M"? 7
Combine three InputBoxes into one? 7
Advice on multiple macros, same code just a different column 9
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Copy columns and paste with blank column between 5
InputBox for column letter problem 2

Back
Top