Sub ts()
ActiveSheet.PageSetup.PrintArea = Range("A1", "J" & Columns(1).Find("*", lookat:=xlValue, searchdirection:=xlPrevious).Row).Address
ActiveSheet.PrintOut Copies:=1, Collate:=True
End Sub
Sub ts()
ActiveSheet.PageSetup.PrintArea = Range("A1", "J" & Columns(1).Find("*", lookat:=xlValue, searchdirection:=xlPrevious).Row).Address
ActiveSheet.PrintOut Copies:=1, Collate:=True
End Sub