Good day,
I have bellow code for printing two copies of selected range
but I need to fit all columns to one page (A4 ladscape orientation).Sub Print()
Sheets("Table").Select
LR = Range("H" & Rows.Count).End(xlUp).Row
For icell = LR To 1 Step -1
If Range("H" & icell).Value > 0 Then
Range("A6:W" & icell).Select
Exit For
End If
Next icell
Selection.PrintOut Copies:=2, Collate:=True
How to do that?
Bookmarks