Guest User

Untitled

a guest
Dec 17th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. Sub PrintPlease()
  2.  
  3. I = Cells("O24").Value
  4.  
  5. With ActiveSheet.PageSetup
  6. .Zoom = False
  7. .Orientation = xlPortrait
  8. .FitToPagesWide = 1
  9. .FitToPagesTall = 1
  10.  
  11. ExecuteExcel4Macro ("PAGE.SETUP(,,,,,,,,,,,,{#N/A,#N/A})")
  12. If .Zoom < 30 Then
  13. .Zoom = 50
  14. Else
  15. .Zoom = False
  16. .FitToPagesWide = 1
  17. End If
  18.  
  19. End With
  20.  
  21. Range ("B18:J18"), Cells("B18").Offset((I), 3).PrintOut, Preview:=True
  22.  
  23. End Sub
  24.  
  25. Range("B18:J" & Range("O24").Value).PrintOut Preview:=True
Add Comment
Please, Sign In to add comment