Hello
VBA newbie here,
I found a code on the forum to print copies based on cell value, but I need to be able to specify what sheet to print
So I input number in cell on sheet 1 press button with assigned macro that would print out that number of copies of Sheet 2.
Any help would be greatly appreciated
Code
Sub Macro3()
For Each Worksheet In ActiveWorkbook.Worksheets
With Sheets(Worksheet.Name)
If .Visible = xlSheetVisible And _
IsNumeric(.Range("A1").Value) = True And _
.Range("A1").Value > 0 Then
.PrintOut Copies:=.Range("A1").Value, _
IgnorePrintAreas:=False
End If
End With
Next Worksheet
End Sub