Re-sorts all data cells in the region based on the sort conditions. Syntax
Returns the total region including the filter headers (read-only). Syntax
Sets the region where the filter settings should be applied Syntax Parameters address The address of the new region. Exceptions Exception Description System.InvalidOperationException If the region intersects with a table of other reserved area in the worksheet. Remarks The CellReferenceMode of the workbook will be...
Sets the region where the filter settings should be applied Syntax Parameters address The address of the new region.cellReferenceMode The reference to use the parse the address. Exceptions Exception Description System.InvalidOperationException If the region intersects with a table of other reserved area in the wor...
Sets the region where the filter settings should be applied Overload List
Returns the region that the filters and sort settings are applied to (read-only). Syntax
Gets the settings which determine how the data within the worksheets filer region should be sorted. Syntax Remarks Note: Sort conditions are not constantly evaluated as data within the region changes. Sort conditions are applied to the region only when they are are added or removed or when the ReapplySortCondition...
Represents a filter which can filter in date cells if the dates occur between the start of the current year and the time when the filter is evaluated. Syntax
Public Properties
Public Properties