Page Break

[Guest]

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 Before:=ActiveCell

 

[Sharad Naik]

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

 

[Tom Ogilvy]

ActiveSheet.HPageBreaks.Add Before:=ActiveSheet.Range("A3")