Hi all , and a Merry Christmas!
I have been trying to figure out why a piece of vba is not working.
I'm searching through a colum of data that has dates and some cells contain W/C and a date e.g W/C 26/12/17.
I can get the macro to strip the W/C and the space between the text and date however...