Maximum Envelope Value
 

I would like to create a VBA program that will capture the maximum
values of a calculation over a series of trials linked to a scroll bar.


Column #1 Column #2
Current Trial Value Maximum Observed Value
from all trials.

I have a relatively simple way of doing this however it requires 4
lines of code for each cell that I need to do this for and with 300
cells that is 1200 lines of code that really slows down the program and
makes for a lot of typing. Anyone have any suggestions