Udostępnij za pośrednictwem


XmlMappedRange.EntireColumn Property (2007 System)

Gets a Range that represents the entire column that contains 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 EntireColumn As Range
'Usage
Dim instance As XmlMappedRange 
Dim value As Range 

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

Property Value

Type: Range
A Range that represents the entire column that contains the XmlMappedRange control.

Examples

The following code example uses the EntireColumn and EntireRow properties to set the border color of the column and row that contain an XmlMappedRange to green. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub HighlightColumnAndRow()
    ' Set the color of the column and row borders to the  
    ' RGB value for green. 
    Me.CustomerLastNameCell.EntireColumn.Borders.Color = &HFF00
    Me.CustomerLastNameCell.EntireRow.Borders.Color = &HFF00
End Sub
private void HighlightColumnAndRow()
{
    // Set the color of the column and row borders to the RGB value for green. 
    this.CustomerLastNameCell.EntireColumn.Borders.Color = 0xFF00;
    this.CustomerLastNameCell.EntireRow.Borders.Color = 0xFF00;
}

.NET Framework Security

See Also

Reference

XmlMappedRange Class

XmlMappedRange Members

Microsoft.Office.Tools.Excel Namespace