i.e If there are total 6 records in my table,The column Ref No should hold value 310/SA & the column Address should hold value Bedok .
Here the problem is these 2 columns values lies same for all other worksheets,whereas other columns always 've a differing value.So in the given table i m trying to insert data in these 2 columns differently.
Below is my code to insert the values for columns Ref No & Address.
Expand|Select|Wrap|Line Numbers
- rs.MoveFirst
- For i = 0 To rs.RecordCount
- rs.Edit
- rs.Fields(7) = CStr(Range("D39").Value)
- rs.Fields(9) = CStr(Range("A33").Value)
- rs.Update
- rs.MoveNext
- i = i + 1