title: VBA Excel 2016 - Run-time error '1004'
body: <p>I am trying to write code to copy and paste data from one sheet to the master sheet in the same workbook based on 5 drop down lists (using data validation) on the master sheet and have written this code for it as below, however every time I get the run time 1004 error and don't know how to solve it, is there a way to fix this?</p>
  
  <pre><code>Private Sub GO_Click()
  Worksheets("Dashboard").Select
  If Worksheets("Dashboard").Range(B3) = "National Gallery" And 
  Worksheets("Dashboard").Range(B4) = "unframed" And 
  Worksheets("Dashboard").Range(B7) = "Product Costings" And 
  Worksheets("Dashboard").Range(B5) = "N/A" And 
  Worksheets("Dashboard").Range(B6) = "N/A" Then
  Worksheets("(7b)").Activate
  Worksheets("(7b)").Range(A8, F23).Copy_
  Destination = Worksheets("Dashboard").Range(D11)
  
  Else: MsgBox ("No Data")
  
  End If
  
  End Sub
  </code></pre>