How to move an activecell to down in a macro with VBasic

[Guest_imported]

I'm making a macro in excel with visual basic code, I need to move an activecell to down, for example when you want to move an activecell to right write: activecell.next.select
or to left: activecell.previus.select, I can't find a way to move the activecell in another way.

Please this answer will help me a lot.
Bye.

P.D:If you want you can write me to:
cesar_soto@

http://www.com

 

[kevinclark]

You could use the offset ?

Sub Sample()
On Error Resume Next
'ActiveCell.Offset(Row reference, Col reference).Select
ActiveCell.Offset(-1, 0).Select 'Moves Up 1 Cell
ActiveCell.Offset(1, 0).Select 'Moves Down 1 cell
ActiveCell.Offset(0, -1).Select ' Moves left 1 Cell
ActiveCell.Offset(0, 1).Select ' Moves right 1 Cell

'This next example Moves right 1 Cell and Down 2
ActiveCell.Offset(2, 1).Select
End Sub

 

[JasonPurdueEE]

dont know if it will work in your situation, but you might also look at using the sendkeys in something like this:

SendKeys "{down}"