I am doing an excel assignment on Microsoft Excel 2007. There are 4 worksheets in this workbook and one part of the assignment is numbering the pages on the footer. It should be "Page 1 of 4" on the first page, but when I put the code &[Page] of &[Pages], all the pages say page 1 of 1. How do I fix that problem to show the correct page number?