NamedRange.Errors Property

Gets an Errors object that enables you to access error checking options.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property Errors As Errors
    Get

Errors Errors { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Errors
An Errors object that enables you to access error checking options.

Remarks

Reference the Errors object to view a list of index values associated with error checking options.

Examples

The following code example creates a NamedRange and inserts a number written as text into the range, and then uses the Errors property to determine whether the number is written as text.

This example is for a document-level customization.

Private errorsRange As Microsoft.Office.Tools.Excel.NamedRange

Private Sub CheckForErrors()
    errorsRange = Me.Controls.AddNamedRange(Me.Range("C3"), _
        "errorsRange")
    Me.errorsRange.Formula = "'12"

    If Me.errorsRange.Errors( _
        Excel.XlErrorChecks.xlNumberAsText).Value Then
        MessageBox.Show("The number is written as text.")
    Else
        MessageBox.Show("The number is not written as text.")
    End If
End Sub

Microsoft.Office.Tools.Excel.NamedRange errorsRange;
private void CheckForErrors()
{
    errorsRange = this.Controls.AddNamedRange(
        this.Range["C3", missing], "errorsRange");
    this.errorsRange.Formula = "'12";

    if (this.errorsRange.Errors[
        Excel.XlErrorChecks.xlNumberAsText].Value)
    {
        MessageBox.Show("The number is written as text.");
    }
    else
    {
        MessageBox.Show("The number is not written as text.");
    }
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace