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 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
contiguous contiguous ranges current range current range current region current region property currentregion CurrentRegion property Find current region for active cell. Get a range that represents the region of the currently active cell. Range objects Range objects Return region for the selected cell.

See also: