setting page breaks.

R

Rod

My spreadsheet is long and thin so only need to think about horizontal page
breaks.

I want to say fit to X pages vertically with the pages breaks here, here and
here.

I am using .PageSetup.FitToPagesTall = X

and .HPageBreaks(P).Location = .Cells(B4row, 1)

P is the Pth pagebreak and B4row is the row I want the break before. (Have
tried this as a range as well as a cell)

Excel just ignores my efforts

any suggestions??
 
T

Tom Ogilvy

Fit to pages ignores pagebreaks. - just to confirm you observations.

If you want to set the pagebreaks, then you have to control the layout. If
you want excel to control the layout, then it sets the pagebreaks.

You might try setting the pagebreaks and then playing with the zoom setting
until your pagebreak matches the automatic pagebreak.
 
R

Rod

smart idea, ta

Tom Ogilvy said:
Fit to pages ignores pagebreaks. - just to confirm you observations.

If you want to set the pagebreaks, then you have to control the layout. If
you want excel to control the layout, then it sets the pagebreaks.

You might try setting the pagebreaks and then playing with the zoom setting
until your pagebreak matches the automatic pagebreak.
 
D

Dave Peterson

xl2002+ respects those pagebreaks with fit to pages set (well, when you leave
one of the tall or wide boxes empty).

A nice enhancement.

(I'm using xl2003, but I think I noticed this in xl2002, too, er, also <vbg>.)
 

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

Top