Print array code for a series of pages that will also determine print area required?

[matrixpom]

Good day all once again,

I have print code attached to a command button which prints a series of sheets, however some of these sheets will have a changing print area, e.g. depending on how many procedures required will determine the amount of rows that need printing, is there a code that will recognise an empty cell & make that point the print area? - Thank you all & have a great day! - Marco

Private Sub cmdPrint_Click()
Dim ws As Worksheet
For Each ws In Sheets(Array("PAGE 1", "PAGE 2", "PAGE 3", "Page4+", "Final Page"))
    ws.PrintOut Copies:=1
Next ws
End Sub

[JBeaucaire]

I believe you can NOT set a print area at all on a worksheet and it will then result in the sheet only printing the "used range".

[matrixpom]

Thanks for the advice Jerry, guess they will just have to adjust the print area manually then

[JBeaucaire]

That's not what I was suggesting. I was suggesting you "Clear Print Area" on each sheet, then run your macro. With no specific print area, the sheet should only print the used range on each sheet.

[matrixpom]

Hi Jerry,

Sorry, had a blonde moment...works perfect! Have a great day! -Marco