I'm trying to put together VBA code to copy and paste a table from one worksheet to another worksheet in the same spreadsheet.
The difficulty is that my code (when it works) is copying just the first row of data and duplicating it many times over.
The Macro code that I've put together so far is as follows:
' Macro16 Macro
'
'Selection.AutoFill Destination:=Range("AR2:AU" & Range("A" & Rows.Count).End(xlUp).Row)
'Range(Selection, Selection.End(xlDown)).Select
'
Sheets("All Other Hearings").Select
Range("C2:R1000").Select
Selection.AutoFill Destination:=Range("C2:R" & Range("C" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Payment Report").Select
Range("A2").Select
ActiveSheet.Paste
Range("A2").Select
Sheets("Dashboard").Select
End Sub
Is there anything obviously wrong with this code which is leading to the duplicated first row in all rows in the pasted to worksheet?
Thanks in advance?
Bookmarks