macro to set print area

[JasonLeVan]

in cell u1 i have a number 1 maybe 2 maybe 3, but what ever that number is is what i want to set the number of pages to print thru. so if it say 2 it will print pages 1 and 2 through a macro

 

[JamesW]

Hi,

Does this help?

Sub test()
    nPages = Range("U1").Value
    ActiveWindow.SelectedSheets.PrintOut From:=1, To:=nPages
End Sub