title: returning row number only in vba
body: <p>In excel vba is there way for getting only row number from range.</p>
  
  <pre><code> set range=selection
  </code></pre>
  
  <p>Selection can be complete multiple row consecutive on or non consecutive or only cells it depend on user before running micro.
  following line can give me row number but like this it will repeat the row for each cell but I want only row number only one time from any number of cells selected in row. </p>
  
  <pre><code>for each cell in range
  
      cell.row
  
  next cell
  </code></pre>
  
  <p>or </p>
  
  <pre><code>for each range in SelectedRange.rows
  
      range.row
  
  next range
  </code></pre>