Hi Experts,

In attached WB there is already one Code is there. In which I want to add one criteria & investigate code as if I do calculation manually it shows criteria meet but while running code it by pass that point.

1.Add this criteria in existing code. Before procedure start.

Copy formula from cell G7 till end "DropDwon". Procedure start.

while procedure running ignore rows in calculation which have "Ignore" in column G.

2.Investigation

Code do this procedure

Copy formula from Cell H2 & I2 till end. if in column I found "Hit" then find lower or higher values from last point date which in range L3:N3 to current hit row date.

Shift down whole data in range L3:N3 one row down & register new data.

Clear all formulas in Column H & I from row 3 till end.

Copy formula from H2 & I2 & past to where last hit found till end.

Query Part

If I put manually formula to row 132 to till end (in attached yellow highlighted) I found "Hit" in row 172 & previous point is High so need to find lowest point from range =MIN(D132:D172) which is 1012.10 in row 162. but code by pass this point. I don't know why?

reply me back if any part is confusing or for question on this issue.

Thanks

Math-G-V04.xlsm