ListObject.SourceType Property

Syntax

expression.SourceType

expression A variable that represents a ListObject object.

Example

The following sample code returns a XlListObjectSourceType constant indicating the source of the default list on Sheet1 of the active workbook.

Sub Test () Dim wrksht As Worksheet Dim oListObj As ListObject Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set oListObj = wrksht.ListObjects(1) Debug.Print oListObj.SourceType End Sub

See also:

• ListObject Object
• ListObject Object Members