Insert Table

Is there anyway to insert a table for a range like you can do in excel? For example, I create a worksheet with 100 rows and then in excel I go to insert...table. This allows for sorting, filtering, etc. In reviewing your docs I see reference to PivotTables but I am looking for a simple table.

I have added a FilterRange and that does allow filtering and sorting. The only other missing piece of the table is the table layout which gives automatic alternate row coloring, etc. I have looked at creating a Style and using the following code for every other row. Worksheet.SetDefaultRowStyle (iRow, Workbook.Styles["ORS_Alt"]); This does not appear to do anything. I am using a styles for my columns as well so I am not sure if this is causing a conflict. What is the easiest and most efficient way to add alternate row formatting for a sheet?

It looks like the following will work; oWorkSheet.AutoFilters.FilterRange = oWorkSheet.Range

Yes, I want to be able to filter/sort a group of rows...basically the entire worksheet. In excel you can do that by saying insert table and then you have a dropdown on the top of each column that allows for the filtering/sorting. Are you saying I can do this with your control?

Hi, it's possible. It looks like you want to use the filter and sort feature. Is that correct?