Thread: Isblank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lishen Lishen is offline
external usenet poster
 
Posts: 1
Default Isblank

Hi,

I'd like to test whether there are any blank cells in range of cells I have.
If there are blank cells in the range I'd like them to return "False" and if
there's something in the range I'd like them to return "True"

The cells I'm checking is text.
I've tried the formula =ISBLANK(C6:H6) but it doesn't seem to work
Can anyone help?

Thanks,
L