Thread: Form Printing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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