Thank you Bob. I inserted your code to the first and the total page count appears in A1, but the macro says there are 3 pages when in fact the print area has 5 pages.