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.

Hi

you are in the wrong forum - Please ask admin or mod to move it to the programming forum

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post