Range.DataTypeToText (Excel)

If any of the cells in the range are a Linked data type, such as Stocks or Geography, this call will convert their values to text.

The call can fail if none of the cells in the range are a Linked data type. In this case, it will throw runtime exception 1004.

ActiveCell.DataTypeToText