XlSpecialCellsValue 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 cells with a particular type of value to include in the result.

Name

Value

Description

xlErrors

16

Cells with errors.

xlLogical

4

Cells with logical values.

xlNumbers

1

Cells with numeric values.

xlTextValues

2

Cells with text.

Show: