Oftentimes I have a range filled with formulas that as such work correctly, but need an error checking mechanism. For example to account for cells that are empty.
This article shows some code to achieve that.
But there is more. I plan to add functionality as we get along, amongst other things an Undo function.
Jan Karel Pieterse