Avoiding widows and orphans on printed page.

[HighAndWilder]

I'd like to be able to avoid widows and orphans, a range being split by a page break.

How can I ascertain which row / rows a page break is on?

I can do the rest once I have that information.

Thanks.

 

[RoryA]

The basic gist is something like:

    Dim theHBreaks
    Set theHBreaks = ActiveSheet.HPageBreaks
    Dim hpb As HPageBreak
    For Each hpb In theHBreaks
        Debug.Print hpb.Location.Address
    Next