View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_2_] Paul James[_2_] is offline
external usenet poster
 
Posts: 5
Default testing for non-empty cells

I need to test an entire column to see if there are any non-blank cells in
the column. I've tried writing an expression using CountA(), but I can't
get it to work.

Can anyone tell me how I could test, say, Column C, to see if there are any
blank cells in that column?

Thank you in advance.

Paul