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