AidanDanby
Board Regular
- Joined
- Jan 24, 2013
- Messages
- 176
- Office Version
- 365
Hi All & Happy New Year,
I have a spreadsheet with a singe worksheet in it named "Mainsheet". Depending on how much info is inputted on this determines how many pages are required to print. The maximum number of page is six. I have written a little VBA so that the correct number of pages are printed but I cannot fathom how to get the footer to be correct. For example if there are 4 pages in total I want it to state 1 of 4, 2 of 4 and so on, on the footer. If 5 pages - 1 of 5, 2 of 5 and so on.
I have looked through Google for help but just cannot find an answer.
Can anyone help please?
Cheers,
Aidan
I have a spreadsheet with a singe worksheet in it named "Mainsheet". Depending on how much info is inputted on this determines how many pages are required to print. The maximum number of page is six. I have written a little VBA so that the correct number of pages are printed but I cannot fathom how to get the footer to be correct. For example if there are 4 pages in total I want it to state 1 of 4, 2 of 4 and so on, on the footer. If 5 pages - 1 of 5, 2 of 5 and so on.
I have looked through Google for help but just cannot find an answer.
Can anyone help please?
Cheers,
Aidan