Sub b()
With Range([A1].End(xlDown)(2), [T44])
.ClearContents
.Borders.LineStyle = xlNone
.Borders(xlEdgeTop).LineStyle = xlContinuous
End With
End Sub
With ActiveSheet.PageSetup
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With