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]

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

 

[Earl Kiosterud]

James,

ActiveCell.Offset(1,0).Select