Excel VBA Number of Printable Pages

When I was younger the hashtag symbol was universally recognised as the symbol for a number. Now it appears as the opening character in a tweet or other social media post. I was recently asked to generate a procedure which would add the page numbers which were to be printed to the bottom of an Excel sheet. The idea was when the file printed the first page had a description which said there will be X number of pages in the current report. Excel does not currently have a generic report pages generator algorithm so here is a starting point.

Tags Excel, Printable, print, pages, VBA, Custom Function, Page Numbers