I'm somewhat new to VBA. I currently have to loop through a sql
recordset, which I already am able to do. I then do a search on
another workbook, looking through a sheet there to find certain things
that match my values from my recordset.
If I find a match, I want to create a row in my current
workbook.worksheet of the current row in the recordset (rsQTS.Fields).
So how do I add a row to the worksheet from a single row from a
recordset?
Joel - 14 Feb 2007 17:02 GMT
Range(Cells(RowCount, 1), Cells(RowCount, SourceLastCol)).Insert (xlShiftDown)
> I'm somewhat new to VBA. I currently have to loop through a sql
> recordset, which I already am able to do. I then do a search on
[quoted text clipped - 5 lines]
> So how do I add a row to the worksheet from a single row from a
> recordset?