Difficult when there is no pattern

You can Filter, Loop or use Find to delete the rows but you must know the criteria
Look here http://www.rondebruin.nl/delete.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"LoriM" wrote in message ...
Hello all. I am working with a 20,000 row data spreadsheet. I have a list of
the rows that need to be deleted (i.e., 31, 38, 52, 66, 81, etc.). There is
no pattern to these rows, just bad data rows that need to be removed (2,000
in all).

Is there a way to automatically define which rows to delete? At the moment,
I am manually going through the list and selecting/deleting. I am pretty
green at programming so detailed answers are very much appreciated!

Thank you all for any suggestions.

LoriM