title: Is there a way to retrieve the cell address of a comment in Excel?
body: <p>I am writing a short macro to manipulate some comments in Excel. It would be useful to have a way to find out the cell address/location of a comment in my active worksheet - is there any way to do this with the comment object in Excel? Or failing that, any clever workaround that would give me the same result?</p>
  
  <p>Some illustrative pseudo-code of what I'm trying to achieve:</p>
  
  <pre><code>dim wb as Workbook
  dim ws as worksheet
  dim cmt as Comment
  
  set wb = ActiveWorkbook
  
  for each ws in wb.sheets
      for each cmt in ws.comments
          debug.print cmt.address ' Pseudo code
      next cmt
  next ws
  </code></pre>