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..
[VBA]
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Sheets("RSRevDiscGIA").HPageBreaks.Add Before:=Sheets("RSRevDiscGIA").Rows(93)
[/VBA]
i have also tried..
[VBA]
Sheets("RSRevDiscGIA").ResetAllPageBreaks
Worksheets("RSRevDiscGIA").Rows(93).PageBreak = xlPageBreakManual
[/VBA]