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

Thanks,
JohnV

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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"JohnV" wrote in message ...
How do you move to the next row from the current row?

Thanks,
JohnV

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

Regards,
JohnV

-----Original Message-----
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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"JohnV" wrote in message
...
How do you move to the next row from the current row?

Thanks,
JohnV

carefully press the down arrow ONCE

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"JohnV" wrote in message
...
How do you move to the next row from the current row?

Thanks,
JohnV

In a bad mood today?
--
HTH
Richard Choate, CPA

"Don Guillett" wrote in message
...
carefully press the down arrow ONCE

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"JohnV" wrote in message
...
How do you move to the next row from the current row?

Thanks,
JohnV

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.

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Richard Choate" wrote in message
...
In a bad mood today?
--
HTH
Richard Choate, CPA

"Don Guillett" wrote in message
...
carefully press the down arrow ONCE

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"JohnV" wrote in message
...
How do you move to the next row from the current row?

Thanks,
JohnV