This is related to my other post about the Automation error, but as it is a completely different question, so I'm posting it in a new thread.

I have an ADO recordset created in VB6. Some of the elements of this recordset is header information, and will only be used once in the, doh, header portion of the spreadsheet.

I have that working just fine. However, there are 8 other elements in the recordset the comprise the sole of the data I'm retrieveing. Like all recordset, I have no idea how many records will be returned during any particular run as the criteria for the SELECT query is user selectable.

My column headers for the data begin at A6 and go to F6. I want the loop that iterates through the recordset to start dumping the contents at A8 through F8 and continue down to Ax where x is whatever column will be the last one.

What I don't know how to do is increment the row number so that it will go from A6 to Ax. How would I do that?

(Note: I'm using Excel 2003 and VB6 SP5)