Hi,
I'm having a problem with excel 2010 i'm hoping someone can help me with. I have a dynamic list that gets formatted for printing, and i'm having trouble getting the manual page breaks to work properly. if I force a pages high x pages wide setting it ignores my page breaks if I don't it takes my page breaks but won't automatically scale the page so it doesn't add the automatic page breaks.
how do i make it so it will automatically only use the manual page breaks and scale it so that there is no automatic page breaks. any help would be greatly appreciated.
Chris
Sub PrintAreaWithpageBreaks()
Dim iRow As Long
Dim LastRow As Long
Dim FirstRow As Long
With ActiveSheet
FirstRow = linecount + 2
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
.ResetAllPageBreaks
For iRow = FirstRow To LastRow Step linecount
.Cells(iRow, "A").PageBreak = xlPageBreakManual
Next iRow
End With
End Sub
Bookmarks