Udostępnij za pośrednictwem


XmlMappedRange.Cells Property (2007 System)

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

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Cells As Range
'Usage
Dim instance As XmlMappedRange 
Dim value As Range 

value = instance.Cells
[BrowsableAttribute(false)]
public Range Cells { get; }
[BrowsableAttribute(false)]
public:
property Range^ Cells {
    Range^ get ();
}
public function get Cells () : Range

Property Value

Type: 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 Sub DisplayCellRange()
    Dim range1 As Excel.Range = Me.CustomerLastNameCell.Cells
    MsgBox("CustomerLastNameCell is in range " & _
        range1.Address(ReferenceStyle:=Excel.XlReferenceStyle.xlA1))
End Sub
private void DisplayCellRange()
{
    Excel.Range range1 = this.CustomerLastNameCell.Cells;
    MessageBox.Show("CustomerLastNameCell is in range " +
        range1.get_Address(missing, missing, Excel.XlReferenceStyle.xlA1, 
        missing, missing));
}

.NET Framework Security

See Also

Reference

XmlMappedRange Class

XmlMappedRange Members

Microsoft.Office.Tools.Excel Namespace