No, the red and green was built into the template, it goes away after the first few programmed cells. NO problem with adding cells as long as when we do, we expand the range before getting to the last named cell in the range.
So you add row A1785 above the named range, which here might be A1790. The range expands by as many lines as you add, as you know.
There is a lot to check when making this spreadsheet. I spent a lot of hours during my research debugging formulas for all the columns all the way out to the D and E columns. Thanks for doing the leg work on the rest of the formulae.
Bill
|