Skip to main content

Errors object

Table of contents
  1. Remarks
  2. Example

Represents the various spreadsheet errors for a range.


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


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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>