Cheers! With a little fiddling it now seems to work, but is there anyway to make it not case sensitive, because i found that it would delete "exp", but not "Exp".
Thanks again.
I'm trying to write a macro that will delete a column in excel if the title has a certain sequence of letters. I can't seem to get the syntax right, or maybe im going about it in completely the wrong way as im an absolute novice when it comes to writing in VBA. So far i've got:
Sub...
