XmlMappedRange.CurrentRegion Property (2007 System)
Gets a Range that represents the current region.
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 CurrentRegion As Range
'Usage
Dim instance As XmlMappedRange
Dim value As Range
value = instance.CurrentRegion
[BrowsableAttribute(false)]
public Range CurrentRegion { get; }
[BrowsableAttribute(false)]
public:
property Range^ CurrentRegion {
Range^ get ();
}
public function get CurrentRegion () : Range
Property Value
Type: Range
A Range that represents the current region.
Remarks
The current region is a range bounded by any combination of blank rows and blank columns.
This property cannot be used on a protected worksheet.
Examples
The following code example uses the CurrentRegion property to set the color of the interior region of an XmlMappedRange to green. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.
Private Sub ColorCurrentRegion()
' Set the color of the region to the RGB value for green.
Me.CustomerLastNameCell.CurrentRegion.Interior.Color = &HFF00
End Sub
private void ColorCurrentRegion()
{
// Set the color of the region to the RGB value for green.
this.CustomerLastNameCell.CurrentRegion.Interior.Color = 0xFF00;
}
.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.