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

This example resizes the selection on Sheet1 to extend it by one row and one column.

Visual Basic for Applications 
Worksheets("Sheet1").Activate numRows = Selection.Rows.Count numColumns = Selection.Columns.Count Selection.Resize(numRows + 1, numColumns + 1).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
Add a row and column to a table? Change the size of a selected range? Increase the size of a named list? resize Resize Property Shrink a specified range by one row?

See also: