Printing problems with hidden rows

B

Banker

I have a sheet with 5 templates divided by page breaks. When only 2
templates are needed, I hide the rows that I do not wish to be printed so it
will only print 2 sheets instead of 5. This was working just fine until
lately. Now it prints all 5 sheets but sheets 3, 4 & 5 are blanks. The
print area is set for A1..H340 but I may hide A200 .. H340. Any ideas as to
what has changed??
 
B

Banker

I figured it out. There was a print area defined and when I cleared the
print area, it worked as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding rows and printing 1
Hiding Rows when printing 1
Printing a worksheet with a Drop Down List 1
Copying worksheets with formulas in hidden columns 2
Hiding/Exposing Rows based on a cell value 10
Cancel printing a worksheet 1
Again printing with hidden rows 3
Can't We Set Print Area with condition? 10

Top