title: automatically execute an Excel macro on a cell change
body: <p>How can I automatically execute an Excel macro each time a value in a particular cell changes?</p>
  
  <p>Right now, my working code is:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("H5")) Is Nothing Then Macro
  End Sub
  </code></pre>
  
  <p>where <code>"H5"</code> is the particular cell being monitored and <code>Macro</code> is the name of the macro.</p>
  
  <p>Is there a better way?</p>