Selecting and deleting rows based on criteria

[mancubus]

Good code mancubus!

thanks Marcel. yours is too. the OP states "process all workbooks in a specific folder" so i used a variable for that specific folder. but if it changes, it will be a good practice to enable user to browse for folder containing the files to be processed. using LIKE operator for "partial matches" is also a good idea for row deletion. i assumed it's a full match.