Range.End Property[
^] -
Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW.
Range("A2:IV" & Range("A65536").End(xlUp).Row).Copy
Above code means:
Range("A65536").End(xlUp)
- find first not empty cell in A column
.Row
- get the number of row
and finally...
.Copy
- copy "selected" range ;)