activating cells

[Ryan H.]

Hi,

I have an active selected cell in a worksheet. I want to be able to select
the cell that's three rows down. How can I address that cell so I can modify
it?

Thanks

 

[Norman Jones]

Hi Ryan,

One way:

Dim rng as Range
Set rng = Activecell.offset(3)

 

[Leo Zhang]

another way:

Cells(Activecell.Row+3,Activecell.Column).Select