nagivating rows and columns
 

hello,
i am trying to fill in some data.
i will know that there are always 6 columns.
and i have a variable that has the rows in it. iRows.
i am trying to find a good way to nagivate through the cells.
i see there is a range.next. which i can move to the right with.
is there a down method?
so i have:
Set oCell = Range("A9") 'start cell
oCell.Value = "<value"
Set oCell = oCell.Next


thanks in advance

nagivating rows and columns
 

Set oCells = Range("A9").Resize(iRows,1)
For Each oCell In oCells
oCell.Value = "<value"
Next oCell

--

HTH

RP

"greg" wrote in message
...
hello,
i am trying to fill in some data.
i will know that there are always 6 columns.
and i have a variable that has the rows in it. iRows.
i am trying to find a good way to nagivate through the cells.
i see there is a range.next. which i can move to the right with.
is there a down method?
so i have:
Set oCell = Range("A9") 'start cell
oCell.Value = "<value"
Set oCell = oCell.Next


thanks in advance