asking for code meaning

[petelam]

Range("A" & (.Rows.Count - .Cells(1, 1).Row + 2)).copy _
Destination:=[A65336].End(xlUp).Offset(1, 0)

Can I ask how to control the destination, let say to paste the stuff into another sheet.

Thanks!!

 

[TonyJollans]

Hi petelam,

The destination is a range in the same way that the source is, but first ...

The line of code you give doesn't specify precisely where you are copying from (it must be subordinate to a "With&quot, but the reference you have provides the cell in column A which is one row below the bottom of the range (if its from a worksheet it is specifying A65537 - an invalid address).

Assuming that you are providing a valid reference then to copy it to another sheet, just qualify the detsination reference with a sheet ...

Range("A" & (.Rows.Count - .Cells(1, 1).Row + 2)).copy _
Destination:=

Sheets("Sheet2").

[A65336].End(xlUp).Offset(1, 0)

Enjoy,
Tony