macro row movement

I

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?
 
B

Bob Phillips

Activecell.Offset(3,0).Select

--
HTH

Bob

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

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?
 
G

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
 
B

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)
 
Top