I am trying to program in a page break before row c. It is really delaying
my program because I think that it takes a while to select a row. I would
like to execute a page break without having to select a row. Here is what I
have. Thank you very much

Rows(c).Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=ActiveCell

With Workbooks("xyz.xls).Worksheets("SheetName")
.HPageBreaks.Add Befo= .Rows(c)
End With

"Adam" wrote in message
...
I am trying to program in a page break before row c. It is really delaying
my program because I think that it takes a while to select a row. I would
like to execute a page break without having to select a row. Here is what
I
have. Thank you very much

Rows(c).Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=ActiveCell

ActiveSheet.HPageBreaks.Add Befo=ActiveSheet.Range("A3")


--
Regards,
Tom Ogilvy


"Adam" wrote in message
...
I am trying to program in a page break before row c. It is really
delaying
my program because I think that it takes a while to select a row. I would
like to execute a page break without having to select a row. Here is what
I
have. Thank you very much

Rows(c).Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=ActiveCell