Macro to Delete Columns

[Kim B]

Hi All. I am looking for a simple macro auto fit columns and delete columns N,P,Q,R,T so leaving O,Q,S,U

It will always be those columns to delete but the trick is the data is pulled down daily so if it possible to have the macro run on each new workbook as it is pulled down

I have tried using record macro but there seems to be no option in store macro in drop down that will work with a new workbook. if I select new workbook, it's not there unless I am doing something wrong when setting up the record macro.. I was usin shortcut key r

As always thank you in advance

 

[Kim B]

ok, as you suggested, I have posted a separate request with both requests (delete, resize) and extract to separate workbooks.

Sorry for the confusion. Thank you in advance if you happen to pick it up again. I will also mark the post that has the solution to the resize/delete request.

 

[craig2525]

This is what I was searching for to delete columns. One questions is why does this code create a new workbook? I have a button set up to use this code.