Search results for query: *

The purpose is exactle what is indicated in subject and Combo's tip provided the necessary to achieve it. Your input however does not fit my question.

SkipVought, please have a look at the details of my question. Putting everything in a single is the reason for this discussion (4,000 styles limit)... ;-)

Indeed combo. Right now I cannot give you the eact thread reference but I found in this foum a good routine for page counting per active sheet. Given that I also have to treat the data from each worksheet, I am already looping through all and therefore activating each. I will work on this...

Well, SkipVought, following combo's tip, it is then easy to create a macro to read a set of user-selected workbooks or contained in a folder, calculate the number of pages in the first, add last page number+1 to first worksheet of 2nd workbook, etc., until all are then paginated sequentially...

Well, if it was my choice, the source workbooks would be properly formatted and the number of styles udes would be far less. But the final document produced my code puts together between 30 and 50 workbooks, each containing from a mere 1 up to more than 30 worksheets! Currently, the final...

Thanks combo, didn't think in that direction! Indeed, it works! Really simple...

Sorry but that works for the worksheets within a single workbook only. I want to be able to paginate continuously across multiple workbooks

I would like to be able to define my pagination across multiple workbooks. Excel is able to paginate continuously a series of grouped worksheets if "First page number" is set to "auto" in the page setup. The issue is that I would like set the first page number in the following workbook to the...