Locating a 'word' within cell with more then 1 word

[netcbc]

Hi I have the current code which is working well however instead of just searching for the cell that has just "COMPLETED" in it I would like it to still work if the cell contains "COMPLETED" with other words in it, for example "completed January".

Thank you in advance!

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[DonkeyOte]

might want to add the following to remove case sensitivity

Please Login or Register  to view this content.

or else convert to common case

Please Login or Register  to view this content.

[shg]

might want to add the following to remove case sensitivity

Indeed, thank you.

[netcbc]

wow you guys are awesome thank you so much