Delete Rows based on what it finds?

[Hyflex]

Hey Guys,

I think this is fairly simple to create but I'm having problems...

I need a macro to go through all of column "A" and search for the exact word "Logic" as the whole cell

If it finds it, then it needs to delete itself and the 3 rows above
However it must start searching from 19 and lower, so it must ignoring the one found in row 18

Thanks in advance
- Hyflex

[AB33]

Please Login or Register  to view this content.

[AB33]

OR

Please Login or Register  to view this content.

[bstier]

I just added two lines to AB33 code.

Please Login or Register  to view this content.