The Resize is another property of Range property. Resize is the opposite of Offset property. In Offset property the starting position is changed. But in Resize property the starting position will not change. It is very simple to understand the Resize and Offset property. Just remember the Reference cell location and then how many rows and columns you wish to jump from it.
Offset vs Resize Example 1:
As previously discussed, I'm going to example direct here. Below codes telling you that the Reference location is "A1". That means your cursor placed in A1 cell. Now how many Rows and Columns you wish to jump?
The code mentioned Offset(2,3) means, next 2nd row and next 3rd column will select. That means the final location will D3 cell.
For Resize property, if you use the same thing:
The Reference cell is "A1" and then rows to go 2nd and columns to go 3rd. So, if I ask you, what is the range resize property will select from the above code? The answer is A1:C2.
Note: In Offset property the Reference cell A1 is a 0 (Zero). But in Resize property the Reference cell A1 is 1 (One).
Offset vs Resize Example 2:
Assume that your reference cell is "B4" and now you wish to select the range A2:D5, then what will be the code? Here you can apply the range which is combination of Offset and Resize property.
Offset vs Resize Example 1:
As previously discussed, I'm going to example direct here. Below codes telling you that the Reference location is "A1". That means your cursor placed in A1 cell. Now how many Rows and Columns you wish to jump?
Sub resized()
Range("A1").Offset(2,3).Select
End Sub
The code mentioned Offset(2,3) means, next 2nd row and next 3rd column will select. That means the final location will D3 cell.
For Resize property, if you use the same thing:
Sub resized()
Range("A1").Resize(2,3).Select
End Sub
The Reference cell is "A1" and then rows to go 2nd and columns to go 3rd. So, if I ask you, what is the range resize property will select from the above code? The answer is A1:C2.
Image 1: Resize property
Note: In Offset property the Reference cell A1 is a 0 (Zero). But in Resize property the Reference cell A1 is 1 (One).
Offset vs Resize Example 2:
Assume that your reference cell is "B4" and now you wish to select the range A2:D5, then what will be the code? Here you can apply the range which is combination of Offset and Resize property.
Sub resizez()
Range("B4").Offset(-2,-1).Resize(4,4).Select
End Sub
Image 2: Offset and Resize property combined