Hello! I find that when I use references to other cells (A1's formula is =$M$2, etc.), when I delete the values in those cells (M2), A1 formula sometimes doesn't do a #REF error.

So, what would be the best way to recurse all the cell formulas on a sheet and then list via msgbox those cells that have formulas which reference empty cells?

Thanks!

VR/Lost