Resize returns a range with the same top-left cell and a new number of rows and columns.

Code

Range("A1").Resize(lastRow, 3)

• Size to the data

  Range("A1").Resize(lastRow, 3) → A1 down to row lastRow across three columns

  Size to the data.

• Drop the header

  rng.Resize(rng.Rows.Count - 1).Offset(1) → The range without its header row

  Skip a header.

• Write an array

  Range("D1").Resize(UBound(v, 1), UBound(v, 2)).Value = v → Writes an array back to exactly the right size

  Array write-back.

• Omit an argument to keep that dimension.
• Pair with Offset to skip headers.
• Resize before assigning an array, or only the first cell is written.

• Resize does not move the top-left cell; Offset does.
• A size of 0 errors.