title: get active cell without using macro
body: <p>I need to get the address of the active cell in cell A1 </p>
  
  <p>I can do it woth a macro</p>
  
  <pre><code>Sub Worksheet_selectionchange(target as range)
  Cells(1,1)=activecell.address
  End sub
  </code></pre>
  
  <p>The problem with this solution is that the user looses the undo...</p>
  
  <p>Any ideas?</p>