title: Excel VBA - Performing function to each cells in range
body: <p>Let's say I have a range called rng1</p>
  
  <pre><code>Set rng1 = Worksheets("Sheet1").Range("A1","A5")
  </code></pre>
  
  <p>Is there a quick and easy way to perform a mathematical function, lets say divide all those cell values by 2, for all the cells in rng1?</p>
  
  <p>Any help is appreciated!</p>