HPageBreaks.Add

[Stephen Plotnick]

I'm using VB 2005 and Excel 2007 and cannot figure out how to insert a page
break before line 72. I've tried several ways but always get an exception
error.

Thanks in advance.

 

[Dave Peterson]

I don't speak the VB, but if I were doing it in VBA, I'd use:

Option Explicit
Sub testme()
Dim myCell As Range
Set myCell = Worksheets("Sheet1").Range("A72")
myCell.PageBreak = xlPageBreakManual
End Sub

 

[Stephen Plotnick]

Thanks, I do not think this works for VB.

I don't speak the VB, but if I were doing it in VBA, I'd use:

Option Explicit
Sub testme()
Dim myCell As Range
Set myCell = Worksheets("Sheet1").Range("A72")
myCell.PageBreak = xlPageBreakManual
End Sub