Remove zeros from sheet

hi, fusion007, can you post sample workbook showing original data and the result you need to obtain?

Originally Posted by snb

Please Login or Register  to view this content.

snb thanks very much for the code but this just removes the zero values and leaves the lines in. I want to remove the whole lines that have 0.00 in the debit and credit columns (columns I and J).
Thanks

Thanks snb. i will need to enter the code in between another code so what do I need to replace the sub snb() with. Mt last part of the code is to save the workbook and I will enter this code to remove the zero lines before this.
Thanks

Hi snb...I used this code

Please Login or Register  to view this content.

and it deletes all rows after the first row with the zeros irrespective of whether there are values in columns I and J. Please help!

Hi please find attached sample workbook. In this example I want to remove rows 2 and 5 from the worksheet as the amounts in columns I and J are 0.00
Thanks

Hi snb...your code will delete all rows that has a 0 in column 9 which is why I've noticed that everything has been deleted when I ran the code.
I only want to delete rows where both columns 9 and 10 have a zero in them.
Thanks