ListObject.SourceType Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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