ListDataFormat.Type Property (Excel)
Returns an XlListDataType value that represents the data type of the list column.
Syntax
expression .Type
expression A variable that represents a ListDataFormat object.
Remarks
This property is used only for lists that are linked to a SharePoint site.