PageBreak

[matrixindicator]

I generate along code from access an output to excel.

recordset1
create a table in excel

recorset2
create a second table in excel

between these two recordsets I like to insert a pagebreak with vba. So I get one table on page one and the second on page 2 (in the same worksheet). What is the instruction to insert a pagebreak ?

 

[SkipVought]

Hi,

It would be a better practice to put each on a SEPARATE sheet, and then print the workbook (ie both sheets, which will be on separate pages)

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[matrixindicator]

xlWorkSheet.Rows(lLastRowPageBreak).PageBreak = xlPageBreakManual

I first generate my result (output) and set then a PageBreak on a position. I don't see the difference between xlPageBreakManual and xlPageBreakAutomatic

 

[SkipVought]

Remarks
This property can return the location of either automatic or manual page breaks, but it can only set the location of manual breaks (it can only be set to xlPageBreakManual or xlPageBreakNone).

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[SkipVought]

Do the research.

Then ask questions.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}