...
Introducedin |
---|
...
|
...
|
Description |
---|
Excerpt |
---|
The AutoFilter class represents the filter that is applied to a selected area of cells in a worksheet. |
Signature | ||||
---|---|---|---|---|
| ||||
public sealed class AutoFilter
|
Signature | ||||
---|---|---|---|---|
| ||||
Public NotInheritable Class AutoFilter
|
Remarks |
---|
To return an There is only one auto filter per worksheet; by default, the filter is not set and |
...
...
will return |
...
|
...
. When applying an auto filter to a select area of cells on a worksheet, bear in mind: |
...
...
|
...
...
|
...
|
...
...
|
...
|
...
|
...
|
...
The filter will be removed from the worksheet either by calling the filter's |
...
...
method, by setting the |
...
|
...
property to |
...
|
...
, or by deleting all the rows (or just the first row that has the filter headers) or all the columns of the filter from the worksheet. |
...
Example | |||||||||
---|---|---|---|---|---|---|---|---|---|
|
...
|
...
|
...
|
Exceptions |
---|
Exception | ||||
---|---|---|---|---|
| ||||
An exception of type |
...
|
...
will be thrown if the |
...
|
...
property is set to an area that is on a different worksheet, or an empty area that doesn't have any data in it. |
...
Properties |
---|
Name | Description | |
---|---|---|
|
...
|
...
|
Methods |
---|
Name | Description | ||||
---|---|---|---|---|---|
|
...
|
...
|
...
|
...