delete rows when values in cell =0

[tdyl1969]

I have a file that has 20,000 rows. the rows include various information in 10 columns. How would I delete all rows that have a 0 in a particular column?

Thanks for the help.

[Cyclops]

Try this.

Replace Columns(3) with the appropriate column (A = 1, B=2, etc)

Will delete all rows that have a value of zero. Cells with zeros and blank cells.


If it takes too long to run, it can be sped up by "marking" all the rows during the loop and then deleting all applicable rows in a single step.

Please Login or Register  to view this content.