Quote Originally Posted by Kyle123 View Post
AS per the comments in my code, you need to amend the column that you are checking for the word in. Without a more accurate mock-up I'm struggling to help any further really, just set break points in your code and inspect the locals to try and suss it out.
Ok Let me upload amy workbook then :-)