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:

4 37 -12 2 3 -1, the max would be 41 taken from the first two numbers. If it was

-6 -14 6 15 22 -9, it would be 43 (from 6, 15, 22).

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.

Thank you :)