Hi,

In an Excel Spreadsheet I want to do a macro that will delete all rows that contain AWR in Column J.

Do I have to do some sort of loop that will start at the top (or bottom row), check to see if AWR is present and if so delete that row and then move onto the next row until the end of the data is reached.

Or is there an easier way to do the same thing?

Cheers,

Bren.