LinkBack URL
About LinkBacks
I have the below which deletes all rows above if it finds the string anywhere in a cell. I want to alter it so that it only does this if it finds the EXACT word in the cell.
Please Login or Register to view this content.
I have the below which deletes all rows above if it finds the string anywhere in a cell. I want to alter it so that it only does this if it finds the EXACT word in the cell.
Please Login or Register to view this content.
Hi,
Change this line to :
Change the text "ExactWord" with the word you want to find.Please Login or Register to view this content.
Regards
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Highlights what you added and says Named Argument Not Found...
Sorry, a typo, it should be :
RegardsPlease Login or Register to view this content.
As posted by karedog you need xlWhole and if your question mark is a string i.e. you aren't using it as a wildcard (can't tell by your question) then you need to put a space after the ?
i.e.
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
solved. thanks guys.
You are welcome, glad I can help.
@WasWodge : Nice tip, nice avatar too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks