View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mika.[_2_] mika.[_2_] is offline
external usenet poster
 
Posts: 5
Default Check if (part of) a row is blank.

How would one check if an entire row is blank?
Apparently
ActiveWorkbook.Worksheets("Ballot").Rows(4).next < ""
does not work.

As a follow up to that, I only want to check if, out of
columns A-F, whether B-F is blank for a particular row.
But I don't want to do this by column by column, I would
like to check the whole row (minus column A) in one shot.
Is this possible? Any help would be greatly appreciated.

Thanks,
Mika