h2g2 The Hitchhiker's Guide to the Galaxy: Earth Edition

This must be very easy but I can't for the life of me find out how to do it. In a visual basic macro all I want to do is move the active cell down. (It's just part of a loop that goes down a column looking for something.)

One quick and dirty way (assuming that you know the range you're manouvering within):

Sub AddressRows()
Dim i As Integer

For i = 1 To 10
Range("A" & i).Value = "Row " & i
Next i

End Sub

If you don't know beforehand how many cells, you're going through, you may use the CountA function to find out:

i = Application.WorksheetFunction.CountA(Range("B:B"))

Or use rangeselection.row to find starting and ending row numbers and work it out...?

Probably you could use a For Each...Next - but I haven't done that for a while...