View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CR[_2_] CR[_2_] is offline
external usenet poster
 
Posts: 50
Default Checking row for data

I have a worksheet with 16 columns and 54 rows.
Each row has a range D6 to S6, D7 to S7 ect.

I want to run a macro that checks each range to verify that only 6 columns
in each row have data entered.
I guess a dialog box or something to tell me which ranges have <6 or 6 in
them.

Thanks, much appreciated

CR