Need Excel equivalent to Lotus down, up, left right.

[ddmld]

Hello,

I would like to know what is the Excel equivalent to Lotus'down, up , left right.

Ex:
{up 3}
{left 4}
{down 5}

I am trying to write a macro to move the cursur in variable positions but this formula is my sticking point.

 

[Andrew Poulsom]

Use the Offset method, which takes 2 arguments, Row and Column. So:

Activecell.Offset(1,0).Select

selects the next cell down

Use negatives for up and left.

 

[ddmld]

THANK YOU! THANK YOU! THANK YOU!