I have an Excel table with about 20 columns and approx. 400,000 rows of data. Column J contains numerical data and I need to delete some of the rows based on the numbers in this column.

I need a macro that looks at every cell in column J and runs a test something along the lines of "is the value in this cell less than 0 or greater than 10?" and if this returns true I need to delete the entire row.

Can anyone help with how to go about this as I have no idea really!

Thanks
-Rob