I have a range of cells named "Reuse_Estimate" (B22:B24 in my worksheet) that
need to have something entered in all cells. Once a value is entered in all
cells, I need to check that the range named "Reuse_Total" is a specific
value. I have the code for the latter, but am not sure how to check that the
Reuse_Estimate ranges are not blank. Any suggestions?

Thanks