Related question to this previous post: Deleting all but a few columns

[iekika13]

I just read this following post:

http://www.excelforum.com/excel-prog...w-columns.html

My question is, what if you wanted to delete columns that contains a specific word in the header?

For example, I have the following columns:

Individual_email_address
Ind_emailaddress
Email_Address_Ind

And I want to delete the entire column that contained the word "email"

Any help is greatly appreciated!

[HSV]

This will maybe do the trick.

Please Login or Register  to view this content.

[iekika13]

oh goodness, you are a lifesaver!

One additional question:

If I was searched for multiple keywords (ie. "email", "id", first", etc)...will it work if I seperate them by commas in the code you provided or do I need to enter new lines with or statements?

I'm new to VBA and trying to learn. Thank you SO MUCH for your response!

[HSV]

Test it in a testfile.

Please Login or Register  to view this content.

[iekika13]

I have to say, Harry, you are my hero. That worked perfectly.

Thank you!

[HSV]

Thanks for all your praise.