Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. Sub Hello()
  2. For Each myWorksheet In Worksheets
  3. myWorksheet.Activate
  4. With myWorksheet
  5. Dim Lastrow As Integer
  6. Lastrow = myWorksheet.UsedRange.Rows.Count
  7. Dim intLastStartRow As Integer
  8. intLastStartRow = 12
  9. For Each myCell In Range("B12:B" & Lastrow).Cells
  10. Dim lastRange As Range
  11. If (myCell.Borders(xlEdgeLeft).LineStyle <> xlNone) Then
  12. Dim borderRange As Range
  13. Set borderRange = myWorksheet.Range("B" & myCell.Row)
  14. If (borderRange.Value <> 0) Then
  15. myWorksheet.Rows(myCell.Row + 1).PageBreak = xlPageBreakManual
  16. intLastStartRow = myCell.Row + 1
  17. Else
  18. myWorksheet.Rows(intLastStartRow & ":" & myCell.Row).Delete
  19. End If
  20. End If
  21. Next
  22. End With
  23. Next
  24. End Sub
  25.  
  26. last = myWorksheet.Cells(myWorksheet.Rows.Count, 2).End(xlUp).Row
  27. For x = last to 12 Step -1
  28. 'Do Stuff
  29. Next x
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement