XlSourceType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Identifies the source object.


Name

Value

Description

xlSourceAutoFilter

3

An AutoFilter range

xlSourceChart

5

A chart

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

Show: