DevanG
07-27-2011, 05:56 AM
Having a problem setting a page break on a page of mine. The code steps through and I watch it, but the automatic page break stays and no page break is added. The automatic page break is around line 83. I need it at 93 instead.
My latest attempt looks like this..
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Sheets("RSRevDiscGIA").HPageBreaks.Add Before:=Sheets("RSRevDiscGIA").Rows(93)
i have also tried..
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Worksheets("RSRevDiscGIA").Rows(93).PageBreak = xlPageBreakManual
My latest attempt looks like this..
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Sheets("RSRevDiscGIA").HPageBreaks.Add Before:=Sheets("RSRevDiscGIA").Rows(93)
i have also tried..
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Worksheets("RSRevDiscGIA").Rows(93).PageBreak = xlPageBreakManual