Sub M_snb() for each it in array("A","B","C","D") columns(1).replace it,"",1 next columns(1).specialcells(4).entirerow.delete Range("F1,K1").EntireColumn.Delete ' to delete columns F & K in 1 go End Sub
Sub M_snb() for each it in array("A","B","C","D") columns(1).replace it,"",1 next columns(1).specialcells(4).entirerow.delete Range("F1,K1").EntireColumn.Delete ' to delete columns F & K in 1 go End Sub