XlSourceType Enumeration
| Excel Developer Reference |
Identifies the source object.
| Name | Value | Description |
|---|---|---|
| xlSourceAutoFilter | 3 | An AutoFilter range |
| xlSourcePivotTable | 6 | A PivotTable report |
| xlSourcePrintArea | 2 | A range of cells selected for printing |
| xlSourceQuery | 7 | A query table (external data range) |
| xlSourceRange | 4 | A range of cells |
| xlSourceSheet | 1 | An entire worksheet |
| xlSourceWorkbook | 0 | A workbook |