title: Prevent formula references from updating when inserting a row
body: <p>I have this formula entered into my sheet</p>
  
  <pre><code>=COUNTIFS(Liste!B2:B504;"*";Liste!E2:E504;"*14*")
  </code></pre>
  
  <p>I also have a VBA script which automatically adds a row into Sheet[Liste]. This results in my formula ALSO updating — but I don't want that to happen. </p>
  
  <p>How can I lock the field so it doesn't change the B2:B504 to B3:B505 whenever the VBA script runs?</p>