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.
expression A variable that represents a Range object.
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.
This code will convert the range E5:G10 into text.
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.