Resize

 

The Resize property in Excel VBA makes a range (border below for illustration only) a specific number of rows and columns larger or smaller. The Resize property always takes the top left cell of a range as the starting point.

Code line:

Range("A1:C4").Resize(3, 2).Select

Result:

Excel VBA Resize Property Result

Explanation: this code line resizes Range("A1:C4") to 3 rows and 2 columns and selects this range.

Code line:

Range("A1:C4").Resize(, 1).Select

Result:

Excel VBA Resize Property Result

Explanation: this code line resizes Range("A1:C4") to 1 column (we omit any row specification) and selects this range.

4/14 Completed! Learn more about the range object >
Back to Top: Resize   |   Go to Next Chapter: Variables