title: Type mismatch after copy/pasting to multiple cells?
body: <p>I am trying to make a small Excel macro that auto executes upon cell update:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Target.Value = "N/A" Then
          Target.Interior.Color = RGB(205, 201, 201)
      End If
  
      If Target.Value = "Pass" Then
          Target.Interior.Color = RGB(0, 255, 0)
      End If
  
      If Target.Value = "Fail" Then
          Target.Interior.Color = RGB(255, 0, 0)
      End If
  
  End Sub
  </code></pre>
  
  <p>However, when I try to copy and paste any cell(s) across multiple other cells, I get this error:</p>
  
  <p>Run-time error '13':
  Type mismatch.</p>
  
  <p>Why is that and how can I fix it?</p>