Hi,

I have a workbook containing multiple worksheets having multiple ranges (same range names on each worksheet). I'm trying to find a way to loop through each worksheet and print each defined ranges on it (only the data of each worksheet changes) with a different page number.

Since the end result can be 50 pages or more, I would like to combine into one single printpreview, printout (for a pdf printer) or directly to pdf. The single printout combination is really my issue since I am able to launch all pages separately.

Is there someone who know how I can achieve this?

Thanks!