title: How to get address of adjacent cell?
body: <p>I have the following vba code to find occurrences of "0" in a following column:</p>
  
  <pre><code>For Each c In Range("B:B")
  
          If c.Value = "0" Then
              MsgBox "0 found at " &amp; (c.Address)
          End If
      Next c
  </code></pre>
  
  <p>How can I modify the code so that when it finds a "0" at say, B6, it displays C7? ie. it display the cell diagonally adjacent to the one where the "0" is found.</p>