Guest User

Untitled

a guest
Jan 19th, 2018
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. Set ws = ThisWorkbook.Worksheets(i)
  2. With ws
  3. For i = 200 To 1 Step -1
  4.  
  5. identif = .Cells(i, 3).Value
  6. idftl = Left(identif, 2)
  7.  
  8. If Not idftl = "SW" Then
  9. .Rows(i & ":" & i).Delete
  10. End If
  11.  
  12. Next i
  13. End With
  14. Next n
  15.  
  16. End Sub
Add Comment
Please, Sign In to add comment