title: VBA: Finding max value of sum among continuous numbers
body: <p>I have a table which goes from A1 to ALL1 (1000 values), I have to find the max value of consecutive numbers for example if I had these six values:</p>
  
  <p>4 37 -12 2 3 -1, the max would be 41 taken from the first two numbers. If it was</p>
  
  <p>-6 -14 6 15 22 -9, it would be 43 (from 6, 15, 22).</p>
  
  <p>I have to do this in VBA from randomly generated numbers (figured that part out so it's good), but can't figure out this part and then I have to return the position of the first and last value in my sequence. So please some help would be greatly appreciated as I'm not quite a VBA wizard.</p>
  
  <p>Thank you :)</p>