Macro to delete all columns in a workbook based on header name

[Kencosgrove]

Hi

I am aware this has been asked before but I can't seem to apply any of the solutions to my situation..

I need a macro that deletes all columns from a workbook that have a certain name "Update" (there may also be another column I want to delete, named "Action required")

Thanks!

[ptmuldoon]

Does this work for you?

Please Login or Register  to view this content.

[Phixer]

Is each column header in row 1 of the worksheet?

If so:

Please Login or Register  to view this content.

Should work, provided you don't ask it to check an empty sheet (that will result in an error).

[skywriter]

You can try this code.

It will work on the sheet that is active when you run the macro or it can be modified to run on other sheets.

Code assumes your headers are in row 1.

If you have other header names, or don't want to delete action required, then modify this line in the code, by either adding or deleting header names.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Kencosgrove]

Does this work for you?

Please Login or Register  to view this content.

hi, thanks for this but I am having a bit of trouble running this code. I click the play button and nothing happens? Is there some other lines of code I have to add? I have set macro security settings to allow but there must be something else...

[Kencosgrove]

You can try this code.

It will work on the sheet that is active when you run the macro or it can be modified to run on other sheets.

Code assumes your headers are in row 1.

If you have other header names, or don't want to delete action required, then modify this line in the code, by either adding or deleting header names.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you, this works How do I modify it so it runs for all the sheets in the workbook? Sorry, bit of a VBA newbie to say the least

[skywriter]

You can try this.
Thanks for the rep. points.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

Please Login or Register  to view this content.