Resizes the specified range. Returns a Range object that represents the resized range.
Syntax
expression.Resize (RowSize, ColumnSize)
expression An expression that returns a Range object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| RowSize | Optional | Variant | The number of rows in the new range. If this argument is omitted, the number of rows in the range remains the same. |
| ColumnSize | Optional | Variant | The number of columns in the new range. If this argument is omitted, the number of columns in the range remains the same. |
Return value
Range
Example
The following example resizes the selection on Sheet1 to extend it by one row and one column.
Worksheets("Sheet1").Activate
numRows = Selection.Rows.Count
numColumns = Selection.Columns.Count
Selection.Resize(numRows + 1, numColumns + 1).SelectThe following 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.
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.count - 1, tbl.Columns.count).Select