ListRanges Enumeration
Specifies the range of a ListObject that has changes.
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
| Member name | Description | |
|---|---|---|
| DataBodyRange | The change occurred in the DataBodyRange of the ListObject. | |
| HeaderRowRange | The change occurred in the HeaderRowRange of the ListObject. | |
| None | The change did not occur in the DataBodyRange, HeaderRowRange, or TotalsRowRange. | |
| TotalsRowRange | The change occurred in the TotalsRowRange of the ListObject. |
The ListRanges enumeration is used by one of the parameters of the ListObjectChangeHandler delegate.
The following code example creates a ListObject and an event handler for the Change event. The event handler uses the ListRanges values to display the location of a changed range. To raise the Change event, add text to one of the cells in the ListObject and then press ENTER.
This example is for a document-level customization.