title: Worksheet_Change Event giving run-time error 13 - Type Mismatch When Inserting Rows
body: <p>I'm using Excel VBA and have a worksheet_change event like so:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target = Range("rel_type") Then
         --some code
      End If
  End Sub
  </code></pre>
  
  <p>That code works great when I make a change to the named range "rel_type".  However if I insert a row anywhere else in the spreadsheet, I get run-time error 13 - type mismatch on the first line of that Sub.  Does anybody know a workaround?  I'm not that familiar with the Worksheet_Change event and can't seem to find good documentation (or at least documentation that references why this error would occur).  Thanks.</p>