MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Page Numbers on Group Break


Posted by Gary W. Hill on April 28, 2001 12:02 AM


I use the Headers and Footers to display the Date, Report name, & page number. Is there a way to reset the page number to (1) when the group breaks. Typical example is salesman with totals for the month. You want to start a new page when the salesman number changes.

Thank You


Posted by Mark W. on April 28, 2001 1:35 PM

Gary, take a look at these Excel 97 Help topic for
the Report Manager, "Combine views and scenarios
into a printed report".

Posted by Gary Hill on April 30, 2001 11:07 PM

Hi Mark:

I already looked at that option, however it forces you to define a view for every break.

I was wondering if there is a way to accomplish this with VBA Code.

Thanks