How do I move ot next row in macro

[JamesL]

I have an excel macro where I need to tell the selection to move down one
row from the currently select row.

What is the correct syntax to do that?

James Lysaght

[Norman Jones]

"JamesL" <[email protected]> wrote in message
news:[email protected]...
>I have an excel macro where I need to tell the selection to move down one
>row from the currently select row.
>
> What is the correct syntax to do that?


Hi James,

ActiveCell(2, 1).Select

However, it is rarely necessary (and is usually inefficient) to make
physical selections. So, instead of selecting, you might do something like:

With ActiveCell(2, 1)
If .Value > 10 Then
.Interior.ColorIndex = 36
Else
.Interior.ColorIndex = 5
End If
End With

---
Regards,
Norman

[Earl Kiosterud]

James,

ActiveCell.Offset(1,0).Select

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"JamesL" <[email protected]> wrote in message
news:[email protected]...
>I have an excel macro where I need to tell the selection to move down one
>row from the currently select row.
>
> What is the correct syntax to do that?
>
> James Lysaght
>