Macro to delete specific rows

Having a hard time with this...

I need to search thru 'X' amount of rows, delete the row if it contains the text 'LVL', and the six rows before it, and the one after it. So if LVL is in A55, rows 49 thru 56 will be deleted. The 'LVL' text will only show up in column A. The group of rows I want to delete repeats itself thru the sheet.

Thanks.

Try this code in a macro

Please Login or Register  to view this content.

What determines "X"? I assumed the last used row. I also assumed that you don't have any cells in column A highlighted as red. I wanted to try a thought that I had so I highlighted the rows to be deleted first then come back and delete them. Using the Find/Next method would probably work better here, I just wanted to use Instr since it has been a while. Let me know how it works.

Please Login or Register  to view this content.

It never goes into the while portion of the code. It skips to the end.

Changed a couple things with your advice... this seems to be working.

Please Login or Register  to view this content.

I see your point. My apologizes I didn't make that clear about 'X'.