Move Cursor Down in Macro

[berg891832]

How do have the cell cursor move down one cell for each loop of my macro. I want my macro to loop 10 times moving down one cell each time.

Thanks

bill

 

[Juan Pablo González]

ActiveCell.Offset(1).Select

 

[berg891832]

thank you.

 

[Mudface]

<pre>
Dim i As Integer

For i = 1 To 10
ActiveCell.Offset(1, 0).Select
' your code
Next i
</pre>