Problem with interpolating data

I have a problem with interpolating. When the residuel of a data point (polyline-data point) is 2x standard deviation (allready calculated), then I want reject the data point and it appears red, "rejected" and thick. Then I want to interpolate with the previus and next datapoint.

When 2 datapoints are rejected after each other this no longer goes. When this is the case I want to replace the data point with the polyline value.

I tried to make something, but it runs stuck.

Please Login or Register  to view this content.

Do you not just need to test the cells before loading their contents into a variable. That way last know usable values will be kept.

If you need more help it would be useful if you could post example data set.

How do you think this should work? Maybe you mean if the cell in the next row is "Rejected"?

Please Login or Register  to view this content.

And you appear to be double counting. You increment the variable Counter and the CheckedRow variable by Counter.


Why not add a do loop within the test for Rejected so you just move over those cells.

Please Login or Register  to view this content.

This runs without error but I have no idea whether the output is correct.

Please Login or Register  to view this content.

Yes it does indeed something.

What I would like is if there are two or more rows in a column after each other that are called "rejected" then I want to paste a value from the polycolumn to those cells. Otherwhise I interpolate with the macro, how to program that?
what is wrong about the following?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Perhaps it would make things clearer if you posted a workbook that included examples of the calculated results you are expecting.

Please Login or Register  to view this content.