Step 5: So here is our selection before the execution of the code. Selection.Resize(numRows + 2, numColumns + 2).Select Step 4: Now we can use the resize property to increase the selection by two rows and two columns. Step 3: Now let us provide the selection with the number of rows and number of columns using the selection property method as shown below.

Step 2: First let us activate sheet 1 first using the worksheet property method. Step 1: In the same module let us begin with a subprocedure. For this example, we will first select some range which will have some number of rows and columns and we will use this resize property to select 2 extra rows and column from the selection. For this, follow the below steps: Now let us use this resize property in a dynamic example. It selected one column but the entire four rows. Step 5: Run the Code by hitting F5 or the Run button. Step 4: Now we will use the select method. Step 3: Now we will use the resize property but we will remove the row specification from the code. Step 2: Now we can select any random range. Now let us see what happens when we do not provide one of the arguments to the function. For this, follow the below steps: So in the above examples, we saw how to resize property works if there is same number of rows and columns or a different number of rows and columns as the argument. Out of the range A1:C4 this code has selected three rows and two columns. we can see the following result in sheet 1. Step 5: Now when we execute the above code by hitting F5. Step 4: And the final step is to use the Select property method for the illustration. Step 3: Then we will use the resize method and select the row and column size for the arguments. Step 2: Now as this is a range property we will use the range method to reference a cell. Step 1: We can use the same module and begin with our subprocedure for the second example. Let us try a different approach and use different selection such as row size to be 3 and column size to be 2. For this, follow the below steps: In the above example, we have used the same number of rows and columns for the range. We have selected two rows and two columns to the range. Step 6: Run the Code by hitting F5 or the Run button. and see the result in worksheet 1.

Range('A1').Resize(RowSize:=2, ColumnSize:=2).Select Step 5: Then we can use the select method property for illustration purposes. Step 4: After that, we can use the dot operator and use the resize method to select the number of columns and rows.

Cannot resize excel sheet