Hi there,

I have a workbook with multiple sheets which have multiple pages in the sheets. I want to insert page X of Y into the right footer of the all sheets so that when I print them the page number will be inserted while starting the first page number at 17.

I have tried numerous methods none of which seem to work properly. I was wondering if anybody has a macro that can do this automatically for me and save me loads of time in writing them in manually.

Cheers