Delete column based on string value

[stephme55]

Hello. I wrote this code to delete a column if there is a particular value. Can I write it more efficiently? Also, I would like it to look in the entire column rather than in a specific row, because I'm not sure if the value will always be in that row. Thanks.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[TMS]

Or:

Please Login or Register  to view this content.

Regards, TMS