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

See also

ListObject Object