Hello all,

I condcuting a search in VB and my results are placed into a .mdb

In Visual Basic, I have the records of the search results pass to excel. The only problem I encounter is if i have ten records that are displayed from cell a10 to a20....
I need to display more records four spaces after the last record .. so in other words I need to display my other results at cell a24... The last cell from thefirst set of records can not be determined untl the query is cmplete...

Can anyone make a suggestion or add onto what I have:

Here it is...

rsRecords.MoveFirst
For i = 0 To rsRecords.RecordCount - 1
myWorksheet.Cells(i + 8, 1) = rsRecords("Lastname").Value
If rsRecords.EOF = True Then Exit For
rsRecords.MoveNext
Next i

This will display the records one after the other that works fine



Steve