Home » Forums » Open Source Learning Center » Question and Answer

Macro to Delete Column A and Column F

Submitted by walterusher on 16 August, 2013 - 10:01

Hi All

I need assistance with a macro that will delete Column A and Column F [in every worksheet] of the workbook

Also one that will delete Row 1 to Row 5 same conditions as the columns

Thanks in advance

‹ Pivot Table not picking up all values making a table easier to view? ›
»

Don't think you need a macro

Submitted by tori1964 on 23 August, 2013 - 14:06.

If you open the workbook - click on the first tab - then while holding the shift key - click on the last tab - all of the tab should now be highlighted. While all of the tabs are highlighted perform the delete column function and you will have deleted that column from all tabs - same process for deleting rows. Be sure to then click on a single tab before doing anything else or you will continue to make changes to all sheets in the workbook.

»