How to make a Dynamic Range with Offset

If you want to make a dynamic range in column A, for example.
Dim rng As Range
With ActiveSheet

Please Login or Register  to view this content.

Assumes data begins in cell A2.
The 1 in the 'Cells(Rows.Count, 1).End(xlUp) statement indicates the column number and can also be designated using the alpha characters in quotes, e.g. "A".
This syntax effectively goes to the bottom of the column and comes back up until it finds a cell with data, so if you add or delete rows it will automatically adjust to the size of the data range.