navigate on a sheet down "x" rows

[Guest]

How can I navagate down a sheet "x" rows, make that cell active, where "x" is the value in a cell.

 

[Vasant Nanavati]

Hi:

ActiveCell.Offset(x).Activate

Regards,

Vasant.

How can I navagate down a sheet "x" rows, make that cell active, where "x"

is the value in a cell.

 

[Guest]

Offset works great when I put a value in for "x", but how do I make it look up the value in cell "i1" and use that as the value for "x"
thanks in advance
----- Vasant Nanavati wrote: -----

Hi:

ActiveCell.Offset(x).Activate

Regards,

Vasant.

How can I navagate down a sheet "x" rows, make that cell active, where "x"

is the value in a cell.

 

[Dave Peterson]

ActiveCell.Offset(range("i1").value).Activate

that's i1 (eye-one)?

 

[Guest]

You are the man!

thanks for the answer!