I have a spread sheet that averages 40 pages. At any time a page may be added or deleted. I need the page number and number of pages to be added to each page without using Header and Footer. I have accomplished this using formulas but it is extremely slow. Is there a VB solution to my problem?
Hello Stephen0374,
Welcome to the Forum!
Can you be more specific about a "page"? Is it a an entire worksheet or an actual page that would be printed when the worksheet is printed or something else?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
The worksheet is divided into an equal number of pages of the same size. The whole worksheet is printed once a month.
How is a page added or deleted?
Is the page added or deleted always the final page/s, or are they anywhere within the worksheet?
Hello Stephen0374,
So you have a single worksheet that is printed monthly divided into pages. Are the page breaks automatic or manual, or both?
The pages that are removed can be from anywhere in the spreadsheet. Could be from the end or in the middle. Also, the page breaks are set automatically for the same size pages.
How about a simple formula in each page number cell that references the cell N rows up?
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks