I have a workbook that has 7 worksheets in it (Criteria, Sheet 1, Sheet2, Sheet 3, Sheet 4, Master, Sheet 6, List).

After I run another macro, I want to make excel automatically delete column a from sheet 1 and sheet 2 and then automatically delete column c from sheet 2. Once that is done I need to hide sheets Master, Sheet 6, and List. I have tried this but keep getting errors.

Here is some of the code that I was looking at.

Columns("A:A").Select
    Selection.Delete Shift:=xlToLeft
    Columns("B:B").Select
    Selection.Delete Shift:=xlToLeft
Thanks for any assistance you can provide.