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 wrote:
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