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.
Syntax
expression.DataTypeToText
expression A variable that represents a Range object.
Remarks
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.
Example
This code will convert the range E5:G10 into text.
Worksheets(1).Range("E5:G10").DataTypeToText