Hi
Receive a report in Excel every week, I have to remove some of the rows which is not relevant to division. I want to record a macro to do this, but when I record it the code would like this:

If Range("A12").select
Selection.EntireRow.Delete

I want code that will search through the column A and if the text in the column is "First Line" for example then it should delete the row.