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