Resize Property

         Example         Applies To

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

Syntax

expression.Resize(RowSize, ColumnSize)

expression   Required. An expression that returns a Range object to be resized.

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.