Range.DataTypeToText method (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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.