Getting the above error when I try to run the code in the attached worksheet.

Set My Data is highlighted; any suggestions?

'Open target worksheet
Set myData = Workbooks.Open("C:\Users\The GaffeR\Desktop\Target.xlsx")
Book3.xlsm