Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Resize Column & Row in Excel VBA?

In this post, you’ll learn how to resize column and rows in your Excel spreadsheet using Excel VBA.

Resize Property

The Resize Property of the Range Object will return a new range resized from the original Range object.


The syntax for the Resize property

Range("A1").Resize (RowSize, ColumnSize)

Note: RowSize and ColumnSize must be greater than zero.

Resize Number of Rows and Columns

To resize column and row in Excel VBA


Range("A1:D5").Resize(5, 5).Select

Resize Number Of Rows Only

To resize number of Rows alone,



Resize Number Of Columns Only

To resize the number of Columns alone


Range("A1").Resize(, 5).Select