title: Finding Max of a column in VBA
body: <p>I am trying to find the max value of a cell within A2 to A999. I tried to do a For Loop to loop through each one, but having problems with the logic to find the max rcell. I was hoping there was a built-in rcell.max function?</p>
  
  <pre><code>Set rng = loopset.range("A2-A999")
  For Each rcell in rrng.cells
  'Find the max rcell
  Next rcell
  </code></pre>