XlRangeValueDataType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the range value data type.

Name

Value

Description

xlRangeValueDefault

10

Default. If the specified Range object is empty, returns the value Empty (use the IsEmpty function to test for this case). If the Range object contains more than one cell, returns an array of values (use the IsArray function to test for this case).

xlRangeValueMSPersistXML

12

Returns the recordset representation of the specified Range object in an XML format.

xlRangeValueXMLSpreadsheet

11

Returns the values, formatting, formulas, and names of the specified Range object in the XML Spreadsheet format.

Show: