Skip to Main Content
Writing Excel Macros with VBA, 2nd Edition
book

Writing Excel Macros with VBA, 2nd Edition

by Steven Roman PhD
June 2002
Beginner content levelBeginner
570 pages
16h 48m
English
O'Reilly Media, Inc.
Content preview from Writing Excel Macros with VBA, 2nd Edition

Name

Error Object

Synopsis

Path: Application  --  Range  --  Errors - Error
               

Object

Properties

Error

  • Ignore( ) As Boolean

  • Value( ) As Boolean

Error objects determine whether or not a particular type of error has occurred in a specified range.

In particular, the Errors property of the Range object returns an Errors collection. This collection always contains exactly seven Error objects, corresponding to the seven types of available error-checking options, as shown in the Error Checking tab of the Options dialog box (see the ErrorCheckingOptions entry).

The Error object has a Boolean, read-only Value property that is set to True by Excel if there is an error of the type corresponding to the Error object within the given range.

It is important to note that, in order for the Error object’s Value property to function correctly, the error-checking option must be enabled, either programmatically or through the Error Checking tab.

To illustrate, the following code first turns on global empty cell error checking. Then in cell A1, it places a formula that references one or more empty cells. Finally, the code checks to see if there is an empty cell reference error within the range denoted by rng.

Sub Example_ErrorObject( ) Dim rng As Range Set rng = Application.Range("A1") ' Make sure empty cell error checking is on globally Application.ErrorCheckingOptions.EmptyCellReferences = True ' Insert formula referencing empty cells ' in a cell within the range rng Range("A1").Formula = "=A12+A13" ' Check ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel 2019 VBA and Macros, First Edition

Microsoft Excel 2019 VBA and Macros, First Edition

Bill Jelen, Tracy Syrstad
VBA and Macros for Microsoft Excel

VBA and Macros for Microsoft Excel

Bill Jelen, Tracy Syrstad
Excel 2016 VBA and Macros

Excel 2016 VBA and Macros

Bill Jelen, Tracy Syrstad

Publisher Resources

ISBN: 0596003595Supplemental ContentErrata Page