title: Easy way to find cell reference in excel vba
body: <p>I am working on a spreadsheet with lots of VBA code in it.  Most cell references use numbers, e.g.</p>
  
  <pre><code>Worksheets("Sheet1").Cells(someRow, someColumn)
  </code></pre>
  
  <p>I am wondering if there is any easy way to find out exactly which cell is being referenced - is it possible to put a breakpoint on this line of code, and then see which cell it will refer to (using the traditional "BA10" style) or will I have to calculate it each and every time using <em>divs</em> and <em>mods</em>?</p>
  
  <p>Not all the references are hard coded, and I would really like to be able to work out where data is being pulled from, as the cell is accessed (not necessarily changed).</p>
  
  <p>(edit) Is it possible to do this without changing the original source line, e.g. in an event module or something?</p>