cell moving (New to this)

Posted by Zappy BoB on January 11, 2001 1:56 AM

Hello world, ive only ever recorded macros before and the cant always do what you want!!!
How can i get the macro to move down one cell from the current active cell?

thank you very much
BoB

Posted by Dave on January 11, 2001 2:55 AM

Hi Bob

There are a few ways to do this see below

ActiveCell.Offset(1, 0).Select
ActiveCell.Range("A2").Select
ActiveCell.Offset(1, 0).Range("A1").Select

The third way is what you would get if you Recorded a relative Macro. As you can see though it longer than it needs to be.

Hope this helps
Dave

OzGrid Business Applications