I Have this code which I pieced together from various sources. It copies a row from Sheet1 to another worksheet named sum. It works fine but in the destination worksheet it doesnt paste data into row 1, instead starting at row 2. It means I can put a heading into row 1 on the destination sheet. I cant work out tho , what in the code tells it to choose row 2 instead of row 1? I know its this bit but cant see why it starts at row 2
Heres the full code;
Code
Sub TestCode()Dim c As Integer
Dim wksSource As Worksheet
Dim wksDest As Worksheet
Set wksDest = ThisWorkbook.Worksheets("sum")
Finalrow = Worksheets("Sheet1").Range("b65536").End(xlUp).Row
For c = 1 To Finalrow
x = Range("a" & c).Value
If x = "test" Then
Range("A" & c).EntireRow.Copy wksDest.Range("A" & Rows.Count).End(xlUp)(2)
End If
Next c
End Sub
Display More