I am looking datagrid features like paging and sorting in excel worksheet using VBA. Is it possible.
Currently I am using 1000(Rows) * 10(columns) matrix range where I am adding/deleting rows dynamically.
Is there any possibility to put paging/sorting inside that. for example at a time user can see only 100 rows of data. if user wants to see 101 row then he can simply click on next button and see 101 to 200 rows.
Hopefully looking forward to hearing from you.