Excel.ListObject.SourceType.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ListObject.SourceType property (Excel)	vbaxl10.chm734093	vbaxl10.chm734093	Excel.ListObject.SourceType	17c41741-1bca-0c07-d113-fd68ba7add75	04/30/2019	medium

ListObject.SourceType property (Excel)

Returns an 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 an 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

[!includeSupport and feedback]