Form Printing
I'm looking for a method (to be associated with a command button) that will
print an entire form page, but only if there is data in the top section of the form (Hazard Form). Specifically A1:Q67 will always print If G71 < "", print A68:Q130 If G134 < "", print A131:Q192 and so on Note: G71, G134, etc. have formulas that pull data from another worksheet Thanks -- Suzanne |
Form Printing
Did you want to print each of these ranges on a separate sheet or did you expect
to print these ranges as a continuous range? Suzanne wrote: I'm looking for a method (to be associated with a command button) that will print an entire form page, but only if there is data in the top section of the form (Hazard Form). Specifically A1:Q67 will always print If G71 < "", print A68:Q130 If G134 < "", print A131:Q192 and so on Note: G71, G134, etc. have formulas that pull data from another worksheet Thanks -- Suzanne -- Dave Peterson |
All times are GMT +1. The time now is 04:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com