Thank you for your reply Carim.
Yes, the code I wrote works fine every time, but now that I am adding another column instead of having just "Completed" as a column header, it might say "Online Completed". It would be good to have a code that hides the column if it CONTAINS the word Completed, or any other word I chose. Option b) is just incase the new column does not have the word completed in it but I want to hide it at the same time as the completed column.
I don't know much about VBA, so forgive me if I have this wrong, but doesn't the code you have given hide the column if the cell says "Completed" rather than contains the word completed. I thought it would be like Value = "*Completed*" or something, but I am a novice. A little knowledge can get me into a lot of trouble! Really appreciate your quick reply.