title: excel vba : selected cells loop
body: <p>Would like to iterate each row in a selection in excel VBA.</p>
  
  <p>I have:</p>
  
  <pre><code>Dim rng As Range
  Dim s As String
  Set rng = Application.Selection
  Debug.Print "c :" &amp; rng.Address
  </code></pre>
  
  <p>This prints </p>
  
  <blockquote>
    <p>c :$B$22:$C$29</p>
  </blockquote>
  
  <p>How to make a loop from row 22 to 29/ parse out the start and end row?</p>
  
  <p>And in separate int variables get the start and end column?</p>