How to delete multiple columns

I have a CSV file that has columns from A to GC. I want to delete several of those columns that are not needed. Is there a way to create a VBA function to do this for me? I could manually delete them, but if there is a way to create a function to do this for me would be great.

This won't be the only time I do this, so creating something portable is needed.

Ex: Delete Col D:F, H:Z etc.

Maybe a lookup table with the fields I want and then have VBA delete them.

What do you all think is the easiest way to do this?

To delete columns D to F and H to Z in Excel using a macro, you can use the following VBA code:

Please Login or Register  to view this content.

To run this macro, follow these steps:

Press ALT + F11 to open the Visual Basic for Applications editor.
Insert a new module by clicking Insert > Module.
Copy and paste the above VBA code into the module.
Close the VBA editor.
Press ALT + F8 to open the Macro dialog box.
Select the "DeleteColumns" macro and click Run

Thank you and this is what I thought I would have to do.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.