Footer Automatic Page Numbering - Wrong Page Count When On Right Side

I have a macro/workbook that I use, that gets page numbers wrong occasionally. It was just brought to my attention that on of the other people here had a workbook spit out an 8 page document. It numbered it 1 of 7, 2 of 7, 3 of 7, 4 of 7, 5 of 7, 6 of 7, 7 of 7, 8 of 7. So I started tinkering with the footer. I put the exact same custom footer in the center of the bottom of the page, and it comes out correctly. I left the original on and it still comes out wrong. Any clue on what could be causing this? I am just using &[Page] of &[Pages]