Ah, page breaks:
![]()
Sub x() Dim cell As Excel.Range ActiveSheet.ResetAllPageBreaks For Each cell In Range("C3", Range("C3").End(xlDown)) If cell.Value <> cell.Offset(-1).Value Then ActiveSheet.HPageBreaks.Add before:=cell End If Next cell End Sub
Ah, page breaks:
![]()
Sub x() Dim cell As Excel.Range ActiveSheet.ResetAllPageBreaks For Each cell In Range("C3", Range("C3").End(xlDown)) If cell.Value <> cell.Offset(-1).Value Then ActiveSheet.HPageBreaks.Add before:=cell End If Next cell End Sub
Entia non sunt multiplicanda sine necessitate
OMG your just awesome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks