ListObject.SourceType Property (Excel)
Returns a XlListObjectSourceType value that represents the current source of the list.
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