How to scroll down DataGrid Programatically.

[nismat]

I am using VB6 to read data from Access for Reporting in Excel.
While writing data excel I noticed that not all data is read by my Loop from Datagrid and some data is missing. On furhter investigation found that my loop only reads the rows which are visible in Datagrid.
The rows which are down and not appearing in list and need scrolling causing following error:
6148 - Invalid row number
Any ideas why Datagrid is behaving this way?
Also I think if I could scroll down programatilly, that will resolve this issue.
So
How to scroll MS Datagrid programatically in VB?

Thanks.

[AlexB1234]

If it helps any, an alternative way of doing it would be to work with the dataset, i.e. iterate the recordset that populated the datagrid.