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?
answered 4/26/2018 11:26:55 AM