Djblois
06-13-2006, 11:40 AM
I want to create a macro that would find a word in a column and then every other instance of that code it would delete the whole row.
Ex:
If I am looking for test in Column A, it finds it in (1, 1) and then finds it in the next 5 rows. It will leave the one in (1, 1) alone and delete all the rows that have test in it.(only if it is in the same column.
Ex:
If I am looking for test in Column A, it finds it in (1, 1) and then finds it in the next 5 rows. It will leave the one in (1, 1) alone and delete all the rows that have test in it.(only if it is in the same column.