Hi, is there any way I can determine if all cells in range are blank? Thanx alekm
A alekm Jun 18, 2004 #1 Hi, is there any way I can determine if all cells in range are blank? Thanx alekm
D Dave Peterson Jun 19, 2004 #3 =counta(a1:c99) will count all the cells with something in them. This includes formulas that evaluate to "", too. =if(counta(a1:c99)=0,"all empty","at least one filled!")
=counta(a1:c99) will count all the cells with something in them. This includes formulas that evaluate to "", too. =if(counta(a1:c99)=0,"all empty","at least one filled!")
