View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Guy Normandeau Guy Normandeau is offline
external usenet poster
 
Posts: 29
Default Testing a range for blanks

I have a spreadsheet that has 5000+ rows. Some of the rows have cells 3-10
as blanks. I need to report when these cells are blank. Is there a simple
way to test the range for blanks or do I need to cycle through each cells and
evaluate them?

Thanks in advance.

Guy Normandeau