|re: "Instead of 4 upper and 3 lower rows, can I ask you if you could please change the code as follows…"|
We went back and forth making sure I understood your requirements. You used specific examples to to denote row numbers, columns, etc. e.g.:
Search 'max' in column A1, if 'max' is found in cell A15, then delete 11th row to 18th row
I provide the code to do exactly what you asked for and then you change all of the requirements and expect me to redo my work. Sorry, that's not going to happen.
Let's pretend you are a Project Manager for a major corporation and you gave your vendors your requirements and then sent them off to devise a solution. How much more do you think they would charge you to re-do the solution after you told them "Thanks, now change this, and this and this."?
It should be no different when you are getting free help. We have to set up spreadsheets, write code, test it, etc. We don't save every project we work on and when you come back with different requirements we have to set up everything up again, test it all and re-do a lot of work.
Posting Tip: Before posting Data or VBA Code, read this How-To.