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

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