Excel pagebreak from VB code

I'm working on it.
I will get back to you.
Meanwhile:
I was wondering if the sequence matters.
Maybe page breaks should be inserted AFTER the spreadsheet is populated.
I'm guessing that changing the contents of a cell might negate other attributes.
I'm going to experiment.

Here is a little test page break test.
Some numbers are placed in the first 6 rows of column A.
Then a page break is inserted after row 3:
Note: xl Constants are defined in a "constants" module.

Private Sub TestPageBreak_Click()
Dim iI As Integer
Dim sCellNumber As String
Dim oXLApp As Object
Dim oXLBook As Object
Dim oXLSheet As Object
Dim sWorkbookName As String
Dim sCurrentName As String
'
Set oXLApp = CreateObject("Excel.Application")
Set oXLBook = oXLApp.Workbooks.Add
Set oXLSheet = oXLBook.Worksheets(1)
sWorkbookName = "Testing.xls"
'
With oXLApp
    .Visible = True
    sCurrentName = .Workbooks.Add.Name
    With .Range("A1:F300")
        .Font.Name = "Courier New"
        .Font.Size = 10
    End With
    .Range("A1:A200").ColumnWidth = 5
    .Columns("A:A").Select
    .Selection.HorizontalAlignment = xlCenter
'
' Insert Cell Data
    For iI = 1 To 6
        sCellNumber = "A" & CStr(Trim(iI))
        .Range(sCellNumber).Value = iI
    Next iI
' Page Break
' (alternate try:)
'    oXLSheet.HPagebreaks.Add Before:=oXLSheet.Range("A4")
' using this one:
    oXLSheet.Rows(4).PageBreak = xlPageBreakManual
End With
'
Set oXLApp = Nothing
Set oXLBook = Nothing
Set oXLSheet = Nothing
End Sub

Select allOpen in new window

Two spreadsheets are created!
"Book1" Contains the page break
"Book2" Contains the data.

Please help.

I solved it myself.
Line 17 (code, above) is superfluous, and creates a second spreadsheet.

The link you supplied was interesting reading, though.