VBA, Find Consecutive Repeated "#VALUE!" in Columns

[lahatte]

I have data that has "#VALUE!" in some cells, and I need to interpolate to fill those cells with actual values based on the value above and the value below the missing ones, then set the color of the text in those cells to Red, then continue on to the next "#VALUE!" occurrences. I am trying to write a macro to accomplish this.

Sometimes there are consecutive cells in a column that contain "#VALUE!" (more than one value missing consecutively), so I need to know how to find the number of occurrences of the "#VALUE!" (until there is again a number) so I can know how I need to make selections for the interpolation and the color change. Then continue on to the next "#VALUE!" occurrences.

Thanks!