A simple way to check if range has no value
Posted on 2011-02-18
I have a worksheet that where, in Range B1:B5, I have formulas that can evaluate to numbers or nothing as in "" e.g. =IF(A5,5,""). I could loop through the range and check if all cells contain no values and exit the sub,
However, is there a way I can check the range itself? I can't find any member of the range object that will allow me to test for emptyness.