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
|