Can anyone help?
The attached workbook has two sheets. I need to have rows 35-40 hidden. However, when I go to printpreview (or print), I do not get the bottom border of row 34 (which is not hidden). I have discovered that it's because there's a print_area range defined. On the 2nd sheet, there's no Print_Area range defined and it prints (& previews) fine. WHY?????????? Why can't I set the print_area without this happening?
Interestingly, I hid column "S" and I found that the border still shows when the print area includes up to Column "R". So can anyone explain why this is a problem with the rows but not the columns? I never had this problem printing before. What's now wrong?