macro row movement

[inflnow]

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?

 

[Bob Phillips]

Activecell.Offset(3,0).Select

--
HTH

Bob

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

 

[inflnow]

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?

 

[Gord Dibben]

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

 

[Bob Phillips]

But be careful when you set an offset that you have room to reference that
offset. For instance, if B2 is the activecell, Offset(-2,0) will throw an
error.

--
HTH

Bob

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