Hiding all of the rows on a page

[vlwaring]

I have a workbook that have certain page breaks because it is supposed to mirror a word document.

I have a code that hides all of the rows on a page. When you hide all of the rows, the page that the rows were on still appears, but it is a blank page.

Is there a code that can get rid of this blank page?

Thanks!

 

[Andrew Poulsom]

You could hide the worksheet.

 

[vlwaring]

No because there are other rows on the worksheet (that is split into 14 pages if you were to print). The rows (page) I am referring to is in the middle. So if I were to print the worksheet, there would be 14 pages with one page completely blank. I want 13 and have the blank page gone.

 

[Andrew Poulsom]

Sorry I misunderstood. In Excel 2010 if I hide all the rows on a page that page doesn't print.

 

[vlwaring]

Hmmmmm. I have Excel 2010. Do you think it's because I am viewing it in page layout?

 

[Andrew Poulsom]

I don't see the hidden rows in Page Layout View either.

 

[vlwaring]

Even when you have set page breaks?

 

[Andrew Poulsom]

It works for me provided that I don't have a page break at the top of the page that will be hidden.

 

[vlwaring]

Is there a code that will get rid of the one page break that is on that page?

 

[Andrew Poulsom]

You can set the first hidden cell's PageBreak property to xlPageBreakNone.