I found a way to do this easier, I think...
In my workbook, I created the following:
I have done this to print only the second and third pages of the worksheet called "1st" without doing a print preview. I created this same kind of macro for each of the pages "2nd" through "5th"
This only allows me to print sequential pages, which is not necessarily what was asked by the original post, but I simply wrote:
and that allowed me to print each set of sequential pages at once.
(My first post, so I think I followed the rules...if not, sorry...I will read more closely next time!)
Bookmarks