I have a vba code which deletes rows if cell in Column G is equal to "dog", "cat", "pig".
How can I amend this code such that it deleted if CONTAINS rather than EQUAL?
thank you
Please Login or Register to view this content.
I have a vba code which deletes rows if cell in Column G is equal to "dog", "cat", "pig".
How can I amend this code such that it deleted if CONTAINS rather than EQUAL?
thank you
Please Login or Register to view this content.
Try "*dog*" etc.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
it seems that this does not work, do you have any other ideas?
You could try "like" instead of "=".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks