VBA Excel

[BlindPete]

Andbody know how to insert a page break into an excel worsheet using automation. My application does not have access to the Excel constants and therefore the vbax99.chm is not much help.

'page break here
oWS.Rows(10).PageBreak = 3 'Don't know what the value needs to be
-Pete

 

[TomB]

If you want to add a PageBreak at a specific point then:

YourSheet.HPageBreaks.Add Before:=ActiveCell

Reference the Excel OLB in your VB App and you can see all constants, objects and methods.

Tom