Deleting all rows between two strings

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

Hello Walruseggman. Liking the Beatles reference.

Thank you very much for offering a solution; unfortunately nothing seems to happen when I run it - not even an error.

I've attached the workbook, now with the macro. You'll probably find it works fine and I'm probably being a moron...

Attachment 362617

Best wishes,

Matt

Yeah, I probably should have looked at your example. I wasn't aware that the Library cells would have more text in them than just the word Library.

Anyway, I've tweeked the code and it does delete all your red text cells in your original sheet (the link to the new one you posted doesn't seem to work.)

Let me know how it goes.

Please Login or Register  to view this content.

You're an absolute legend. Thank you very much, that works great!

Cool. Reputation would be appreciated (the * in the lower left of posts), and dont forget to mark this thread as SOLVED

Maybe:

Please Login or Register  to view this content.

Hi John - that worked perfectly too. Thank you very much indeed for your time.