Move to Next Row

[JohnV]

How do you move to the next row from the current row?

Thanks,
JohnV

 

[Ron de Bruin]

Look in the Excel help for offset

Sub test()
ActiveCell.Offset(1, 0).Select
End Sub

Or use this

Sub test2()
Cells(ActiveCell.Row + 1, ActiveCell.Column).Select
End Sub

 

[Don Guillett]

carefully press the down arrow ONCE

 

[JohnV]

Thanks, that did the trick. Was sure where to look.

Regards,
JohnV

 

[Richard Choate]

In a bad mood today?

 

[Don Guillett]

Just being flippant since OP did not say very much about what was wanted.
Formula or vba. Just couldn't resist. I do flip out once in a while.