title: Multiplying every cell within a range by a value
body: <p>I would like that the value of every cell within a range is multiplied by a specific value (let's say 4/7). I have this code, but I'm getting a "Type mismatch error".</p>
  
  <pre><code>Range("B1:B4").Value = Range("B1:B4").Value * 4 / 7
  </code></pre>
  
  <p>Any thoughts?</p>