moving the activecell relative to the current one in excel VBA?

[petey]

Hi,

I'm trying to move my active cell position in a particular direction relative to the current one, no matter where i start..
basically i want the equivalent effect to using the cursor keys to move cells..

how do i do this?? surely this should be simple.. but i'm lost

Thanks for any help

Petey

 

[albywalt]

You can use the offset property in an Excel macro:

ActiveCell.Offset(rows, columns).Select

for example:
ActiveCell.Offset(1, 1).Select
moves down 1 row and over 1 column