title: How to change specific values in a named range
body: <p>This is probably an easy one but I just started using VBA recently. So I defined a single column range of about 10 rows and named it <code>CB_CL_Values</code>.</p>
  
  <p>Lets say the range is <code>{1,2,1,3,2,1,1,1,1,3}</code> and right now it's set up to change every values of the range to 1. </p>
  
  <pre><code>Sub Unit_Options_Reset()
      Range("CB_CL_Values") = 1     
  End Sub
  </code></pre>
  
  <p>Lets say I only want to change values <code>4</code> to <code>10</code> of that range and leave the first <code>3</code> as they are. How would I write this?</p>