Simple VBA: Search string and delete
I am looking for a simple VBA code, to search excel sheet2 for a string "0000X000xx1" and if found in cells then delete everything that is forward and backward of 0000X000xx1 until a line break is found.
Simple VBA: Search string and delete
I am looking for a simple VBA code, to search excel sheet2 for a string "0000X000xx1" and if found in cells then delete everything that is forward and backward of 0000X000xx1 until a line break is found.
You've already asked the same question in the below thread... No need to create a new one. Please mark this thread as [SOLVED] if the provided solutions in the other thread are sufficient
https://www.excelforum.com/excel-pro...-color-it.html
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
How to eliminate multiple blank rows in the excel cell keeping only one between lines as shown in the excel file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks