I was asking earlier about trying to delete a row on one sheet, that is
referenced to another cell on a summary sheet.

Jim T. said it causes the reference to become invalid, so the cell on the
summary sheet displays #REF!

I'm asking now about a macro that would automatically delete whatever row is
now invalid. How would I state that no matter which cell/row is now #REF!,
to delete that row. In other words, if a cell is #REF!, delete that row.

Thanks again.