Hello, I am a VBA novice and have the following problem:
I have a range of cells, each cell containing two sets of staff initials, for eg, JL SW or BN JL
I want to clear the cells that do not contain one of the sets of initials. I have the following code that works fine if there is just JL in the cell so can anyone help amend it to do the same thing but if JL is part of the cell content? Like a wild card? Many thanks.
Please Login or Register to view this content.
Bookmarks