title: Excel passing a range into a function
body: <p>how do you go about passing a range of cells into a function so that you can then process the items separately. Therefore how do I pass a range of cells into a function.</p>
  
  <p>I'm trying to do it so I can have a methods that uses the follow</p>
  
  <pre><code>Function processNumbers(Var as Range) 
  </code></pre>
  
  <p>From this I'm not sure how I can get the number of items in the list and transverse the array to edit the contents. Is there a better way bring in the items than the above.    </p>