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??