title: VBA Changing Value of Multiple Cells
body: <p>I have a row of cells that depending on which option button I have selected, will display a certain range of values. It isn't based on any equations or any logic. I need to display a specific set of values across multiple cells.</p>
  
  <pre><code>Private Sub OptionButton1_Click()
  If OptionButton1.Value = True Then Range("B3","AF3").Value = 
  
  End Sub
  </code></pre>
  
  <p>How would I indicate multiple values across cells in this case? Would I put all my values into some sort of an array first and then just feed the array into the <code>.Value</code>? Thanks! </p>