auto print

[niyrho]

I have a inspection report set so that when you hit the print button it will save the document, clear everything and then print. How do I tell it to only print the pages that are filled out?

[Aussiebear]

Try experiementing with the Selection.printout command

[mdmackillop]

How do I tell it to only print the pages that are filled out?
How do you identify these? Set a Range for each page. Loop through each cell that range that can be filled. If any are completed, print the range.