Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Hello()
- For Each myWorksheet In Worksheets
- myWorksheet.Activate
- With myWorksheet
- Dim Lastrow As Integer
- Lastrow = myWorksheet.UsedRange.Rows.Count
- Dim intLastStartRow As Integer
- intLastStartRow = 12
- For Each myCell In Range("B12:B" & Lastrow).Cells
- Dim lastRange As Range
- If (myCell.Borders(xlEdgeLeft).LineStyle <> xlNone) Then
- Dim borderRange As Range
- Set borderRange = myWorksheet.Range("B" & myCell.Row)
- If (borderRange.Value <> 0) Then
- myWorksheet.Rows(myCell.Row + 1).PageBreak = xlPageBreakManual
- intLastStartRow = myCell.Row + 1
- Else
- myWorksheet.Rows(intLastStartRow & ":" & myCell.Row).Delete
- End If
- End If
- Next
- End With
- Next
- End Sub
- last = myWorksheet.Cells(myWorksheet.Rows.Count, 2).End(xlUp).Row
- For x = last to 12 Step -1
- 'Do Stuff
- Next x
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement