I have a formula that looks for the min value in a range say Min(A2:A5) and a
marco that runs each minute expands the range by one row. So after one
minute the new range is A2:A6, then one min later A2:A7, etc.

What I really need is for the min function to look at a range of one row
less than the range in the formula. I know...sounds wierd but trust me.....

So when the range is A2:A5 If really only want the Min value between A2:A4.
Another words each time the macro runs i want the min value in the range NOT
including the last row.

How do i manipulate the fromula for say A2:A5 to consider only cells A2:A4?

Thx
DaveM