title: VBA How to get values from selected cells
body: <p>I need put data from selected cells to array. How to do it? I cant find any example. I know how to get value from one cell by <code>ActiveCell.Value</code> but how its work with multiple selection. Guess I should selected range put to variable as object and process it by foreach loop. Can anyone write example for it?</p>
  
  <p>Solution: </p>
  
  <pre><code>Sub Button1_Click()
  
  For Each OneCell In Selection
   MsgBox (OneCell.Value)
  Next
  
  
  End Sub
  </code></pre>