Range.Resize (Excel)

Resizes the specified range. Returns a Range object that represents the resized range.

Resize (RowSize, ColumnSize)

Dim rngResize As Range
Set rngResize = ActiveCell.Resize

Arguments

Optional arguments

The following arguments are optional

RowSize - The number of rows in the new range. If this argument is omitted, the number of rows in the range remains the same

ColumnSize (Long) - The number of columns in the new range. If this argument is omitted, the number of columns in the range remains the same.