XmlMappedRange.CurrentRegion Property
Gets a Range that represents the current region.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property CurrentRegion As Range
Range CurrentRegion { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.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.