XmlMappedRange.Cells Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.dll

Gets a Range that represents the cells in the XmlMappedRange control.

public:
 property Microsoft::Office::Interop::Excel::Range ^ Cells { Microsoft::Office::Interop::Excel::Range ^ get(); };
public Microsoft.Office.Interop.Excel.Range Cells { get; }
member this.Cells : Microsoft.Office.Interop.Excel.Range
Public ReadOnly Property Cells As Range

Property Value

Range

A Range that represents the cells in the XmlMappedRange control.

Examples

The following code example uses the Cells property to display the cell location of an XmlMappedRange. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void DisplayCellRange()
{
    Excel.Range range1 = this.CustomerLastNameCell.Cells;
    MessageBox.Show("CustomerLastNameCell is in range " +
        range1.get_Address(missing, missing, Excel.XlReferenceStyle.xlA1));
}

Private Sub DisplayCellRange()
    Dim range1 As Excel.Range = Me.CustomerLastNameCell.Cells
    MsgBox("CustomerLastNameCell is in range " & _
        range1.Address(ReferenceStyle:=Excel.XlReferenceStyle.xlA1))
End Sub

Applies to