Newbie time again, I'm afraid.
The code below runs perfectly until the last line where it generates a 400 error. The syntax looks OK so where am I going wrong? When I save the code it does not generate any error.
My sanity would appreciate any help.
![]()
Sub FieldTransfer() If Sheets("MustDo").Range("TemplateSelect").Value = 1 Then Sheets("MustDo").Range("AA13:AG15").Copy Sheets("Single").Range("D12").PasteSpecial xlPasteValues Sheets("Single").Range("D16").Select End If End Sub
Bookmarks