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
Bookmarks