Delete Columns and hide sheets

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.

dodom75,

Please read forum rules below, I've wrapped your code for you this time.

You could try

Dim Wsht As Worksheet

With Sheets("Sheet2")
    .Columns(1).Delete Shift:=xlToLeft
    .Columns(3).Delete Shift:=xlToLeft
End With

Sheets("Sheet1").Columns(1).Delete Shift:=xlToLeft
    
For Each Wsht In Worksheets
    Select Case LCase(Wsht.Name)
        Case "master", "sheet 6", "list"
        Wsht.Visible = False
    End Select
Next Wsht

VBA Noob

Thank you, this worked perfectly.