Relative range selection

On 2002-07-09 11:21, nbeene wrote:
Very simple question about VBA statement to select a relative range - in the old Excel language I would just write:

=select("r[1]c:r[15]c") - how do I do this in VBA

also, if I have name a cell and want to use the row of it in a reference I would have written it as:

=select("r[1]c:r"&row(!cellname)&"c[5]")

how do I accomplish this in VBA? I am sure it is a simplke thing I just cannot get the syntax right.

Thanks

Click to expand...

On 2002-07-09 11:32, nbeene wrote:
That would give me the absolute reference I was looking for - but I do not think it would be the relative reference. What I am trying to do is if I am in an active cell, I want to select a range say five rows up in the same column to 2 rows up and three colums over - which would be

=select("r[-5]c:r[-2]c[3]")

the brackets imply that the reference is relative and not absolute - I just do not know how to do that in VBA

Click to expand...

On 2002-07-09 12:48, nbeene wrote:
Thanks - that works fine - I am still getting used to the syntax

how about if you want to select everything between the active cell (which may vary, and cell C2), again, I would do it the old way as:

=select("rc:r2c3")

Thanks

Click to expand...

On 2002-07-09 13:00, Barrie Davidson wrote:
Range("C2:" & ActiveCell.Address).Select

should do the trick for you.

Click to expand...

On 2002-07-09 13:04, Juan Pablo G. wrote:

On 2002-07-09 13:00, Barrie Davidson wrote:
Range("C2:" & ActiveCell.Address).Select

should do the trick for you.

Click to expand...

Barrie, FYI, you can just use

Range("C2",ActiveCell).Select

Click to expand...