Hello,

I’d be grateful for your help making a macro to delete all rows between two specified strings.

It would look for two strings, always in column A: "Item Title" and any string beginning "Library" or "LIBRARY".

It would delete all the rows between these cells (including the rows in which these two strings are found).

Notes:
- "Item Title" and "Library*" may appear multiple times in the worksheet, so multiple ranges may require deletion.
- The number of rows between these two strings is unpredictable.
- There may be up to 1,000 rows to check through.

Example Workbook:
The attachment shows a typical initial state. For clarity, I’ve highlighted in red two ranges that I’d like the macro to remove (they wouldn’t be highlighted in "real life"!).

range_deletion_question.xlsx

Thank you for any help you can offer.
Matt