Oh, I forgot to say that D8 does have a formula in it. So that must be why I
get the error--the cell is not blank. Is there anything I can do so it does
not show on spreadsheet.

--