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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for