Hi all,

I have a pretty simple code that prints out Sheet2 from my workbook. However, the number of pages it prints is fixed. I was wondering if there was a way to make this a variable depending on the length of the document.

If the length was 23 pages, it would print 23 pages. If the sheet was 4 pages, it would print four pages.

Thanks for any help!!

Sub Print_All()
Worksheets("Sheet2").PrintOut From:=1, To:=20, Copies:=1, Preview:=True
End Sub