I would like to write a macro that references the cell 2 rows above the
current cell. I typically use hard references ie Range("D7").Select but that
won't work for this instance. I know that R[-2]C would work but i'm not sure
how to incorporate or call that in a macro. Can anyone help?

You probably want to use offset which moves your reference something like
this...

msgbox Activecell.Offest(2,2).Address
or
msgbox Range("A1").offset(2, 2).Address
or
msgbox Cells(5, 5).Offset(2, 2).address
or
msgbox Cells(5, "C").Offset(2, 2).address
--
HTH...

Jim Thomlinson


"Bob" wrote:

I would like to write a macro that references the cell 2 rows above the
current cell. I typically use hard references ie Range("D7").Select but that
won't work for this instance. I know that R[-2]C would work but i'm not sure
how to incorporate or call that in a macro. Can anyone help?

Something like:

activecell.offset(-2,0).select



Bob wrote:

I would like to write a macro that references the cell 2 rows above the
current cell. I typically use hard references ie Range("D7").Select but that
won't work for this instance. I know that R[-2]C would work but i'm not sure
how to incorporate or call that in a macro. Can anyone help?

--

Dave Peterson