jcaptchaos2
Well-known Member
- Joined
- Sep 24, 2002
- Messages
- 1,032
- Office Version
- 365
- Platform
- Windows
I need some help with this code, I want it to ask the person how many copies of "B1:W18" they want and then print out that range that many times, for some reason this code is printing through "W161"
Code:
Sub PrintMe2()
Application.ScreenUpdating = False
Range("B1").Select
Sheets("Standard Label").Select
Dim NumPages As Variant
NumPages = Application.InputBox("How many Labels would you like to Print?")
Do Until IsNumeric(NumPages)
NumPages = Application.InputBox("Must be a number - try again!")
Loop
Sheets("Standard Label").Range("AE1").Value = NumPages
If NumPages = 0 Then Exit Sub
With ActiveSheet
.PageSetup.PrintArea = "$b$1:$w$16" & NumPages
.PrintOut
Sheets("Interface").Select
End With
End Sub