Sub FillFormat()
Dim i
i = [B65536].End(xlUp).Row
Range("B7:L7").AutoFill Destination:=Range("B7:L" & (i + 2)), Type:=xlFillFormats
Range(Cells(i + 3, "b"), [L65536]).ClearFormats
End Sub
Sub FillFormat()
Dim i
i = [B65536].End(xlUp).Row
Range("B7:L7").AutoFill Destination:=Range("B7:L" & (i + 2)), Type:=xlFillFormats
Range(Cells(i + 3, "b"), [L65536]).ClearFormats
End Sub