Range.HasRichDataType (Excel)

True if all cells in the range contain a Rich data type. False if none of the cells in the range contains a Rich data type; otherwise, null. Read-only Variant.

Linked data types, such as Stocks or Geography, are a kind of Rich data type. For linked types, only cells whose LinkedDataTypeState property is xlLinkedDataTypeStateValidLinkedData, xlLinkedDataTypeStateFetchingData, or xlLinkedDataTypeStateBrokenLinkedData will be counted as Rich data types by the HasRichDataType property. Cells in the xlLinkedDataTypeStateDisambiguationNeeded or xlLinkedDataTypeStateNone states do not count as Rich data types. For more information about possible Linked data type states, see the XlLinkedDataTypeState enumeration.

Dim booHasRichDataType As Boolean
booHasRichDataType = ActiveCell.HasRichDataType