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.

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

Thanks, I do not think this works for VB.


"Dave Peterson" wrote in message
...
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