xlSourceType

Specifies the type of source object.

xlSourceAutoFilterAn AutoFilter range (3)
xlSourceChartA chart (5)
xlSourcePivotTableA PivotTable report (6)
xlSourcePrintAreaA range of cells selected for printing (2)
xlSourceQueryA query table (external data range) (7)
xlSourceRangeA range of cells (4)
xlSourceSheetAn entire worksheet (1)
xlSourceWorkbookA workbook (0)

xlSourceAutoFilter
An AutoFilter range (3)
xlSourceChart
A chart (5)
xlSourcePivotTable
A PivotTable report (6)
xlSourcePrintArea
A range of cells selected for printing (2)
xlSourceQuery
A query table (external data range) (7)
xlSourceRange
A range of cells (4)
xlSourceSheet
An entire worksheet (1)
xlSourceWorkbook
A workbook (0)

REMARKS
* Added in 2000.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top