wrong footer in 120 worksheets
 

I have 120 worksheets in one file.
I set print area in some sheets, some not.
I use macro to set up footer. Page number for the first 25 is right.
Then page number becomes 4,5,6,7...... After several sequent pages, the
page number is wrong again. And repeat this again and again.....
Any comments?? Thanks.