Yes

-3 would move up 3 rows.

The 0 is the column designation in the Offset(3, 0)

Offset(0, 3) is same row, 3 columns to right.


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 09:28:03 -0700, inflnow
wrote:

Bob, you're the best. You saved me 2 weeks of growing very old. In the (3,0)
would reversing direction equate to (-3,0) and is the 0 column movement?

"Bob Phillips" wrote:

Activecell.Offset(3,0).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inflnow" wrote in message
...
In Excel 2003 macro, how do you tell the macro recorder to record the
action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work for
me.
Using the "Enter" key pastes from my clipboard so that does'nt work. What
is the simple solution?