Laurence D
New Member
- Joined
- Sep 14, 2016
- Messages
- 31
Hi all,
I want to add page numbers to my workbook to make life easier when printing around 800 pages. Does anybody know how to design a page numbering code to ignore adding page numbers to specific pages based on a certain condition? The condition that I am requiring is that it ignore all pages that have a blank cell on the fourth cell down of a new page (there are three headers). I still want to be able to print these pages it is just unnecessary to have them numbered.
Currently I have code that adds numbers to all pages but I am unsure how to add this step in.
Any help is greatly appreciated
Thanks,
Laurence
I want to add page numbers to my workbook to make life easier when printing around 800 pages. Does anybody know how to design a page numbering code to ignore adding page numbers to specific pages based on a certain condition? The condition that I am requiring is that it ignore all pages that have a blank cell on the fourth cell down of a new page (there are three headers). I still want to be able to print these pages it is just unnecessary to have them numbered.
Currently I have code that adds numbers to all pages but I am unsure how to add this step in.
Any help is greatly appreciated
Thanks,
Laurence