Excel VBA - How to Insert Sequential Page Number
<p>I would like to insert sequential page number across the entire workbook (there are two worksheets in the workbook.</p>

<p>Here is my code to insert page numbers:</p>

<pre><code>ActiveWorkbook.Worksheets("Appendix A").PageSetup.CenterFooter = "&amp;P of &amp;N"
ActiveWorkbook.Worksheets("Summary").PageSetup.CenterFooter = "&amp;P of &amp;N"
</code></pre>