One more thing:
What should the code look like if I want to delete all rows which not hold a
seven digit number in column C?
Hans


"Hans Knudsen" wrote in message
...
I have a sheet with (extract from ERP system) with about 30,000 rows. I
need to delete a lot of them (once a week). Tried the following formula:
=IF(AND(ISNUMBER(C2412),NOT(ISTEXT(B2412))),"","x" )
copied to for example AA1:AA30.000 to get 'x' in rows to be deleted.
Then I use AutoFilter to find all 'x' and try to delete all these rows,
but my Excel to freezes.

Next I wanted to use Ron de Bruin's code
http://www.rondebruin.nl/delete.htm

but I am not sure how to change the code to have it delete rows which both
have a number in column C and where column B is not text. Am I right that
Ron's code is optimized for speed?

Hans Knudsen