April 2006
Beginner
1114 pages
98h 16m
English
pagebreak.Location
Returns the Range object indicating the location of the break. The following code displays the locations of manual page breaks in the Immediate window:
Sub ShowBreakLocations( )
Dim ws As Worksheet, hpb As HPageBreak
Set ws = ActiveSheet
For Each hpb In ws.HPageBreaks
Debug.Print hpb.Location.Address
Next
End SubRead now
Unlock full access