Move to Next Row
 

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

Thanks,
JohnV

Move to Next Row
 

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

Move to Next Row
 

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

Move to Next Row
 

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

Move to Next Row
 

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

Move to Next Row
 

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