Macro Help for Finding and Deleting Specific Columns

[gall3on]

I'm not sure if I should have placed this in the VB forum but I need some assistance with a macro I'm trying to create.

I want to be able to delete a column based on the first row heading. How can this be achieved in a Macro?

For example:
Version Pick Test Verification
1 x Test B
2 d Cntrl C
3 f Test X

I need the Macro to find Col A and Col C and then delete them. The table that needs to get updated is sometimes out of order in columns so I can't just select the same columns. The headings stay the same though. I actually have to find them first and then delete.

Any assistance would be appreciated.

 

[xlbo]

Please post in the VBA forum: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question