|0||An arbitrary range of cells.|
|1||A range of rows.|
|2||A range of columns.|
|3||The entire table.|
This enumeration is used in the creation of ranges. Ranges can be created as a range of rows or columns. A range can also reference the entire table or an arbitrary range of cells.
Ranges that reference an arbitrary range of cells can become invalid if the size of the table changes such that the range references non-existent cells. Ranges that represent ranges of rows or columns are invalidated if any of the referenced rows or columns are removed. However, ranges of rows are not affected by changes to the number of columns.
Similarly, ranges of columns are not affected by changes to the number of rows. A range that references the entire table is not affected by a change to the size of the table. It references the entire table regardless of its size.