PDF every 2 pages

[jhall488]

Hello All,

I am trying to create a PDF of every 2 Worksheets. I currently have this code that creates my PDFs for each individual sheet but I need it to group 2 together. Ex: Sheets 1 & 2 a separate PDF, Sheets 3 & 4 a separate PDF and so on.

Thanks for any help.

Please Login or Register  to view this content.

[shg]

Untested:

Please Login or Register  to view this content.

[jhall488]

Thanks for the quick reply. This code works fine except for the last set of 2 pages. It only returns the first sheet and not the 2nd. Any idea?

[shg]

Please Login or Register  to view this content.

[jhall488]

Works great. Thank You

[shg]

You're welcome.