Printing hidden rows
 

Hi, the requirement is quite simple, yet complex. I am designing a form, in
which based on the selection, the rows have to hide and unhide. Every section
takes up about 10 rows, hence the form is 3 pages long. Now, when i hide the
rows while printing, it prints blank rows (there are 2 buttons at the end of
the form, for Print and Reset). Which means, no matter i want to access 1
section, or more, 3 pages will print (even blank with the header). There are
controls like combobox etc used in form and for validation. Hence deleting
the rows would mess up the code.

Any idea how to print the form based on selection (i tried Range.Selection,
it prints on separate page). Thanks