title: VBA - Worksheet_Calculate event triggers over and over again
body: <p>I am attempting to update a column (E8:E508) with the contents of another reference column (G8:G508) each time the reference column changes, using the following code:</p>
  
  <pre><code>Private Sub Worksheet_Calculate()
      Dim Rng As Range
      Set Rng = Range("G8:G503")
      If Not Intersect(Rng, Range("G8:G503")) Is Nothing Then
          Range("E8:E503") = Range("G8:G503").Value
      End If
  End Sub
  </code></pre>
  
  <p>The code works as intended, but appears to be running over and over again and eventually crashes Excel.</p>