ISBLANK works over a range if it is entered as an array formula.

=ISBLANK(A1:A100) entered with CTRL +SHIFT + ENTER will resolve to TRUE if
A1:A100 is blank and FALSE if one of the cells in that range is not blank.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Don Guillett" wrote:


One cell only
--
Don Guillett
SalesAid Software

"JB2010" wrote in message
...

thanks for that guys, both those work great in this instance.


out of interest, what's up with ISBLANK? why doesnt it want to play ball?