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
Bookmarks