View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Keith Keith is offline
external usenet poster
 
Posts: 262
Default Delete rows with more or less than 7 columns

Good Afternoon,

I have a simple problem that has me scratching my head. I have a report
imported into Excel that I need to clean of unwanted data. I dont have
control over what is sent and this varies considerably.

However, the data that I need is allways in rows and populates columns A to
H. Is there away to delete all the other rows automatically?