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?
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?
Try experiementing with the Selection.printout command
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.Originally Posted by niyrho
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'