Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
Range Object
Properties
AddIndent Property
Address Property
AddressLocal Property
AllowEdit Property
Application Property
Areas Property
Borders Property
Cells Property
Characters Property
Column Property
Columns Property
ColumnWidth Property
Comment Property
Count Property
CountLarge Property
Creator Property
CurrentArray Property
CurrentRegion Property
Dependents Property
DirectDependents Property
DirectPrecedents Property
End Property
EntireColumn Property
EntireRow Property
Errors Property
Font Property
FormatConditions Property
Formula Property
FormulaArray Property
FormulaHidden Property
FormulaLocal Property
FormulaR1C1 Property
FormulaR1C1Local Property
HasArray Property
HasFormula Property
Height Property
Hidden Property
HorizontalAlignment Property
Hyperlinks Property
ID Property
IndentLevel Property
Interior Property
Item Property
Left Property
ListHeaderRows Property
ListObject Property
LocationInTable Property
Locked Property
MDX Property
MergeArea Property
MergeCells Property
Name Property
Next Property
NumberFormat Property
NumberFormatLocal Property
Offset Property
Orientation Property
OutlineLevel Property
PageBreak Property
Parent Property
Phonetic Property
Phonetics Property
PivotCell Property
PivotField Property
PivotItem Property
PivotTable Property
Precedents Property
PrefixCharacter Property
Previous Property
QueryTable Property
Range Property
ReadingOrder Property
Resize Property
Row Property
RowHeight Property
Rows Property
ServerActions Property
ShowDetail Property
ShrinkToFit Property
SmartTags Property
SoundNote Property
Style Property
Summary Property
Text Property
Top Property
UseStandardHeight Property
UseStandardWidth Property
Validation Property
Value Property
Value2 Property
VerticalAlignment Property
Width Property
Worksheet Property
WrapText Property
XPath Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Range.CurrentRegion Property

Office 2007
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. Read-only.

Syntax

expression.CurrentRegion

expression   A variable that represents a Range object.

Remarks

This property is useful for many operations that automatically expand the selection to include the entire current region, such as the AutoFormat method.

This property cannot be used on a protected worksheet.

Example

This example selects the current region on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").Activate
ActiveCell.CurrentRegion.Select

This example assumes that you have a table on Sheet1 that has a header row. The example selects the table, without selecting the header row. The active cell must be somewhere in the table before you run the example.

Visual Basic for Applications
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.Count - 1, _
    tbl.Columns.Count).Select

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.