View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
SIGE SIGE is offline
external usenet poster
 
Posts: 206
Default ISBLANK for a Range

Hi Tom,

It was something which I picked up a while ago .. but could not
remember what formula it was.
I thought it could be useful to explain myself - others in the
formula what the formula does.

& Learned now that the "Commenting" is not flawless... Thank You!

It was just a general question.

=IF(COUNTA(A1:A7)=0;"Blank";"Not Blank")+N("When cells are empty, this
formula returns an error ;o)")

Brgds Sige