nagivating rows and columns

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

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
 
Set oCells = Range("A9").Resize(iRows,1)
For Each oCell In oCells
oCell.Value = "<value>"
Next oCell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Method 'open' of object 'IXMLHTTPRequest' failed 4
select range with resize 3
Last used cell in column 26
Copy and paste entire line starting at cell W 5
Search used cells for values containing named range 2
minor modification to macro, need to delete cells 2
subscript out of range (newbie) 4
filling web forms from excel 1

Back
Top