Macro to delete specific rows

[jchambers]

Lets say i have a spreadsheet with columns A through Z. I want to delete columns A, B, D, and Z. What would the code lool like? What if i also wanted to sum columns C and E individually in row 5 as well.
Im sure this is easy but ive never worked with macros before.

 

[Joe4]

You can get most of the code you need to do these things simply by turning on the Macro Recorder and recording yourself doing these steps manually.

Give it a try and post back with further questions or if you need help generalizing the code.