Share via


XmlMappedRange.SpecialCells Method

Gets a Range that represents all the cells that match the specified type and value.

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

Syntax

'Declaration
Function SpecialCells ( _
    Type As XlCellType, _
    Value As Object _
) As Range
Range SpecialCells(
    XlCellType Type,
    Object Value
)

Parameters

Return Value

Type: Microsoft.Office.Interop.Excel.Range
A Range that represents all the cells that match the specified type and value.

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example uses the SpecialCells method to get and select the range of cells that contain comments within an XmlMappedRange. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub SelectRangeWithComments()
    Me.CustomerLastNameCell.AddComment(("This cell contains " & _
        "a last name."))

    Dim range1 As Excel.Range = Me.CustomerLastNameCell.SpecialCells( _
        Excel.XlCellType.xlCellTypeComments)
    range1.Select()
End Sub
private void SelectRangeWithComments()
{
    this.CustomerLastNameCell.AddComment("This cell contains " +
        "a last name.");

    Excel.Range range1 = this.CustomerLastNameCell.SpecialCells(
        Excel.XlCellType.xlCellTypeComments, missing);
    range1.Select();
}

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace