Hi,

I have a recordset object which is populated with records from a database. Now I want to display the records within the record set on a worksheet in pages.

So if the recordset object had 100 records, I would like to display 10 records per page on a worsheet and the user can just click on a command button [Prev] [Next] to navigate. I would be better if it had also had the functionality to show 1,2,3,4,....so the user can directly go to one page.

Please can anyone help.

Thank you