Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub PrintPlease()
- I = Cells("O24").Value
- With ActiveSheet.PageSetup
- .Zoom = False
- .Orientation = xlPortrait
- .FitToPagesWide = 1
- .FitToPagesTall = 1
- ExecuteExcel4Macro ("PAGE.SETUP(,,,,,,,,,,,,{#N/A,#N/A})")
- If .Zoom < 30 Then
- .Zoom = 50
- Else
- .Zoom = False
- .FitToPagesWide = 1
- End If
- End With
- Range ("B18:J18"), Cells("B18").Offset((I), 3).PrintOut, Preview:=True
- End Sub
- Range("B18:J" & Range("O24").Value).PrintOut Preview:=True
Add Comment
Please, Sign In to add comment