How do I copy the filter area to a new worksheet?

[Wddy]

trafficstars

How do I copy the filter area to a new worksheet？I can do that with Microsoft.Office.Interop。

[swmal]

Filters are not included in the copy function. I'll add this as an enhancement.

They are however included if you copy an entire worksheet viaWorkbook.Worksheets.Add(string name, ExcelWorksheet copy)function.