Excel doesn't directly allow VBA to detect cells that have no precedents or dependents. But through the kluge of forcing an error, it's possible to create this functionality.