I have a workbook where I'll be printing a large number of sheets. I've programatically set the page breaks, page size and all the headers etc required. The data is sorted by an ID code representing each office. Volumes are variable - some office will have only 5 lines of data, some 400 lines and a variety in between. A blank row separates each line of data. I can work out how many lines each of data each office will have. Is there a way to work out how many pages each office will receive when I print the pages? I had thought of using the HPageBreaks.Count property, but I'm not sure how to link that in with the ID code. How do I work out the number of data lines for each office that exist between each page break?

Thanks