Why does this code start the paste at r1c22 in the destination sheet?
[VBA]Private Sub cmdTransferEmpNum_Click()
Dim LastRow As Long
LastRow = Range("A65536").End(xlUp).Row
Worksheets("YTD").Range("A8").Copy _
Destination:=Worksheets("Data Gathering II").Cells(LastRow + 1, 1)
End Sub[/VBA]