Is there any way one may use VBA to 'influence' the first number used by Excel to then automatically paginate across the other worksheets? Because the number of worksheets being put together from several different worksheets then originates a workbook exceeding the 4,000 styles limit, we would therefore need to produce smaller workbooks but then print all sequentially and properly paginated. The reason for this is due to the fact that Excel 2003 has a limit to the number of formatting styles in a single workbook (4,000).

The issue is that I would like set the first page number in the following workbook to the last page of previous workbook +1 and then rely on Excel to automatically renumber the remaining worksheets, and so on until all related workbooks form a single printed document continuously numbered. I would like to be able to define my pagination across multiple workbooks.Įxcel is able to paginate continuously a series of grouped worksheets if 'First page number' is set to 'auto' in the page setup.

How to paginate in excel