Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by VBAJediWannabe
-
Excel - Auto insert page Break when data change.
Hi, Try this: Sub InsertBreaks() Dim myRange As Range For Each myRange In Range([A2], [A65536].End(xlUp)) If myRange.Value <> myRange.Offset(1, 0).Value Then ActiveSheet.HPageBreaks.Add before:=myRange.Offset(1, 0) End If Next myRange End Sub Dom- VBAJediWannabe
- Post #3
- Forum: Microsoft: Office
