Multiple prints

[lapta301]

I have a Data Validation list in C3 which at present has the acceptable values of 0, 16 & 24 although these could change.

What I would like is a macro that would go through and select each of the acceptable values and then print the page.

Each value changes the calculations on the page.

As ever your help is most appreciated.

 

[lapta301]

Hi good to hear from you. Linked to B13 I have a data validation range from H2:J2 with dates that are formatted like 01/12/20
So as before based on B13 in this instance I would like 3 prints for each of the date values.
Similar to your earlier code just dates rather than text.

 

[DanteAmor]

Linked to B13 I have a data validation range from H2:J2

Try this:

Sub MultiplePrints()
  Dim c As Variant
  With Range("B13")
    For Each c In Range(.Validation.Formula1)
      .Value = c
      ActiveSheet.PrintOut
    Next
  End With
End Sub

 

[lapta301]

Thank you again much appreciated

 

[DanteAmor]

Again with pleasure. Thanks for the feedback