View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 59
Default 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