Class Errors (Excel VBA)

The class Errors represents the various spreadsheet errors for a range. To use a Errors class variable it first needs to be instantiated, for example

Dim errs as Errors
Set errs = ActiveCell.Errors

For Each

Here is an example of processing the Errors items in a collection.

Dim err As Error
For Each err In ActiveCell.Errors
	
Next err

Item

Returns a single member of the Error object.

Item (Index)

Index: The index of the member. Can also be one the XlErrorChecks constants.

Dim errItem As Error
Set errItem = ActiveCell.Errors(Index:=1)

Item

Returns a single member of the Error object.

Item (Index)

Index: The index of the member. Can also be one the XlErrorChecks constants.

Dim errItem As Error
Set errItem = ActiveCell.Errors(Index:=1)