title: Get the address of the changed cell
body: <p>I'm trying to trigger a macro (dependant on cell address) whenever any dde linked cell value is changed.</p>
  
  <p>I tried Workbook.SetLinkOnData and Worksheet_Calculate event (with a dummy formula to trigger the event), but the problem is that none of them returns the address of the updated cell.</p>
  
  <p>So is there a way to get the address of the updated cell to use it with my macro?</p>
  
  <p>This is my macro</p>
  
  <pre><code>Public Sub UpdateCell (Byval strTargetAddress as String)
      'Some code
  End Sub
  </code></pre>
  
  <p>Thank u in advance.</p>