Errors object (Excel)

Represents the various spreadsheet errors for a range.

Remarks

Use the Errors property of the Range object to return an Errors object.

Example

After an Errors object is returned, you can use the Value property of the Error object to check for particular error-checking conditions. The following example places a number as text in cell A1, and then notifies the user when the value of cell A1 contains a number as text.

Sub ErrorValue() 
 
 ' Place a number written as text in cell A1. 
 Range("A1").Formula = "'1" 
 
 If Range("A1").Errors.Item(xlNumberAsText).Value = True Then 
 MsgBox "Cell A1 has a number as text." 
 Else 
 MsgBox "Cell A1 is a number." 
 End If 
 
End Sub

Properties

• Application
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

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.