VBA - Delete Columns Excel 2010

[shemayisroel]

Hi,


My data range starts from C1:DH3.

I need some code that starting from D1 deletes 7 columns, misses a columns then keeps on deleting 7 columns misses a columns etc up until Column DH.

Using the example above, the first couple of deletes will delete columns D-J keep column K, delete columns L-R keep S etc

Thanks

 

[chicagodiceman]

This looks like an excellent opportunity to use the "Record Macro" function and complete the task then review the results.

You have very specific requirements but this also allows you to see what code is generated to complete your task.