Hello mehdoush.
Offset will add the row and column values to the range. Resize will change the number of rows and columns for a given range.
In your code the variable c is a single cell value in column "A". Starting with cell "A1", this what happens:
Offset(0, 1) now points the cell in the same row and 1 column over or "B1".
Resize(1, 2) now changes the rows and columns of "B1" to 1 row and 2 columns.
The range pointed to is now "B1:C1"
Offset provides a relative reference using zero based arguments. If the row or column is zero there is no change. A positive number points to the next row down or column to the right. A negative number points to the next row up or column to the left. The table below uses "B2" as the starting point. The results are shown for changing the row and column arguments by 1.
The above referencing technique is the same for Resize with the exception of using zero. Zero is indicated by a missing argument. The missing argument can be indicated by a comma or by using the argument's name.
Bookmarks