![]()
Option Explicit Sub Test1() Dim SH As Worksheet Application.ScreenUpdating = False For Each SH In ThisWorkbook.Sheets With SH .Rows("1:3").Delete Union(.Columns("A:B"), .Columns("G")).Delete .Cells.UnMerge End With Next Application.ScreenUpdating = True End Sub
Bookmarks