I'm using the following code to find text in column C and then delete the entire row if that column contains the text. However I want it to be case sensitive, as in delete "ABC" but not "Abc". Any help is appreciated.
Please Login or Register to view this content.
Unfortunately, the Autofilter function in VBA does not have a string compare attribute that can be applied with the filter. You will have to clean up the filter results with additional code (or manually) if it gives you more that you wished for.
Last edited by JLGWhiz; 02-15-2021 at 02:31 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Try this code ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks