ListObject.SourceType property (Excel)

Returns a xlListObjectSourceType value that represents the current source of the list.


expression. SourceType

expression A variable that represents a ListObject object.


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