Don't understand vb resize code..help needed

Can anyone help in explaining what this line of code means????

With ar.Resize(ar.Rows.Count + 1).Offset(-1, Col)

Hello Darel,

The code is changing the cell to be reference. This is easier to explain using an actual address.

Variable ar is C2:C9
Variable Col is 2

ar.Rows.Count + 1 = 8 + 1 = 9

Using substitution, ar.Resize(9) expands the range reference to C2:C10. One row past the last row in ar. The Resize method has 2 named arguments: RowSize, ColumnSize. Resize(9) so it can be written 2 other ways.

Resize(9,) or Resize(RowSize:=9)

The comma indicates another argument is to follow. If left empty then the row or column remains the same. Personally, I prefer to used the named arguments if only is given. It is easy to miss the comma.

The Offset method creates a reference relative to the range C2:C10. The -1 indicates that row is 1 row up from C2 or C1. The variable Col is 2 which moves the column to the right 2 columns or column "E".

The final reference is then to the range E1:E9.