View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Delete row when zero in column b thru e

See reply at your previous post

---
Regards,
Norman

"Andy" wrote in message
...
Hi All,

I am sorry for posting it twice.
Can some one help me with macro or vba code to delete the row when column

B,,C,D, and E all 4 have the value of 0.
(It has to be 0 in all 4 column). Its very big sheet with thousands of

rows. Please help
I dont want this code to look row 1 thru 6. Because first 6 rows has

headings this Should start from row 7 and end at row till the data ends.

Thanks
Andy