VBA: Search for two values and delete all rows between them

[xerhx]

I have two worksheets, Sheet1 and Sheet2. In Sheet1 i have two cells, B5 and B6 that contain two different values (User can change these). I'm trying to write a code that searches Column A in Sheet2 for the values in Sheet1 B5 and B6, and deletes the rows between them (including the cells that contain the values i search for).

I've been trying to do this for two days, and I can't seem to get it right.

Any suggestions?

Thanks.

Erik

 

[xerhx]

Thanks alot for your time!

It all works perfectly.