MOVE DATA

[Moeses]

Hi,

I am trying to move an entire row from sheet A (Form) to sheet B (Master)
But for some reason, I am getting error # 1004 on line 2 below.
Please help? thank you


Sub Move_data()

Rows.Range("B3:R3").Copy
Worksheets("Master").Range("A3:Q3").End(xlDown).Offset(1, 0).EntireRow.Insert
Worksheets("Form").Activate
Worksheets("Form").Range("B3:R3").ClearContents
Worksheets("Form").Cells(3, 1).Select
Application.CutCopyMode = False

End Sub

 

[Fluff]

You're welcome & thanks for the feedback.