Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I found this macro in this newsgroup, but it is putting the page breaks after
not before the "Results" which in my case is going to be 1/12/2005. Option Explicit Sub insert_pagebreak() Dim lastrow As Long Dim row_index As Long lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For row_index = lastrow - 1 To 1 Step -1 If Cells(row_index, "A").Value ="Result" then ActiveSheet.HPageBreaks.Add Befo= _ Cells(row_index + 1, "A") End If Next End Sub Sub remove_them() ActiveSheet.ResetAllPageBreaks End Sub Thank you for all your help in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using macro for page break | Excel Discussion (Misc queries) | |||
page break preview | Excel Discussion (Misc queries) | |||
Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) | |||
slow page break previews | Excel Discussion (Misc queries) | |||
Page break macro | Excel Worksheet Functions |