View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default Can the column index in a cell address be made variable?

You may be able to use R1C1 terminology, but you'll need to get someone else
to help from here.

"cyberdude" wrote in message
ups.com...
Hi,


To refer to a cell with a variable row number, we can just code it as,
for example,


Dim i As Interger
i=234
Range("A" & i).Select


To refer to a cell with a variable column index, it seems not that easy

because the column
index must be explicitly specified in a cell address. So, if I want to

go to the j th column on the 2nd row or j columns to the right of cell
AA3, is there a quick and easy way to do it? Thank you in advance.


David