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
Errors Errors { get; }
Property Value
Type: 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"], "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.