I am using the macro below to loop through multiple worksheets in my Excel workbook and delete ones that don't contain the inputted keyword.
Is it possible to modify the code to use a pattern instead of a specific keyword (e.g. using Regex or Like Operator)? For example, looking to keep worksheets that contain SSNs (###-##-####). Once one SSN is found in a worksheet, code can move to the next worksheet.. Thanks.
Please Login or Register to view this content.
Hi is you use LookAt:=XlPart you will check on a cell containing the text, the moment it's true exit and continue to the next worksheet if false delete it and continue
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Actually, it only deletes the worksheet if it does NOT contain the specified keyword..
Regardless, still looking for a macro that searches by a regex-type pattern rather than keyword..Thx.
Have you tried then looking for the number format in the cells
I have a cell with theis cusptom format (000)-000-0000 and thta's what the srting value shows, so look for number formats instead and not emptyPlease Login or Register to view this content.
Allright, will mark this as Solved. Came up with a different technique shown below...
Please Login or Register to view this content.
Good one 👍
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks