Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next column
I am using a loop and after walking thru "x" numbers of rows. When I have
walked thru the rows I do the same thing again but I want to move to the next column and grab the next column of data with the I want to move to the next column. How could I accomplish this? Much thanks in advance! Tom Do While Len(Range("A" & r).Formula) 0 And r < 43 ' repeat until first empty cell in column A With rs .AddNew ' create a new record ' add values to each field in the record .Fields("FieldNameN") = Range("B3").Value .Fields("FieldNameN") = Range("e17").Text .Fields("FieldNameN") = Range("A" & r).Value .Fields("FieldNameN") = Range("B" & r).Value .Fields("FieldNameN") = Range("C" & r).Value ' After here I would like to change the column to the next column .Fields("FieldNameN") = Range("D" & r).Value .Fields("FieldNameN") = Range("E" & r).Value ' add more fields .Update ' stores the new record End With r = r + 1 ' next row Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Calculating column A * column B = Results in another column | Excel Worksheet Functions | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) |