Can the column index in a cell address be made variable?

  • Thread starter Thread starter cyberdude
  • Start date Start date
C

cyberdude

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
 
If you just want a single cell, use MySheet.Cells(i,j).
If you want a range, you can use

with MySheet
.Range(.Cells(i1,j1), .Cells(i2,j2))....
end with
 
don't forget to check your post in .misc.
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
Click to expand...
 
Back
Top