title: Multiple cell selection in VBA using ActiveCell.Offset(0, 1).Value
body: <p>I'm starting in VBA and had to do a program that is able to retrieve value from a selected cell which will be used as reference.</p>
  
  <p>I'm able to do it when I select one cell with the <code>Activecell</code> function and playing around with the <code>ActiveCell.Offset(0, 1).Value</code> etc.
  However how to make the same thing while selecting multiple cells at the same time and be able to take the 1 cell value at a time and do <code>Activecell.Offset...</code> then identify the second cell value and retrieve the proper information and so on.</p>
  
  <p>Using macro recorder I see that when I select multiple values it point to</p>
  
  <pre><code>Range("Y8,Y9,Y10,Y11").Select 'etc....
  </code></pre>
  
  <p>Thank you for your help and hope I've been precise enough on what I'm trying to do.</p>
  
  <p>Many thanks
  olivier</p>