Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. Dim LR3 As Long, i3 As Long
  2. With Sheets("Productos")
  3. LR3 = Range("A" & Rows.Count).End(xlUp).Row
  4. For i3 = LR3 To 2 Step -1
  5. If IsNumeric(Sheets("Productos").Range("A" & i3).Value) Then
  6. Else
  7. Rows(i3).Delete
  8. End If
  9. Next i3
  10. End With
  11.  
  12. Sub Sample()
  13. Dim LR3 As Long, i3 As Long
  14.  
  15. With Sheets("Productos")
  16. LR3 = .Range("A" & .Rows.Count).End(xlUp).Row
  17.  
  18. For i3 = LR3 To 2 Step -1
  19. If Not IsNumeric(.Range("A" & i3).Value) Then .Rows(i3).Delete
  20. Next i3
  21. End With
  22. End Sub
  23.  
  24. Sub Sample()
  25. Dim LR3 As Long, i3 As Long
  26.  
  27. With Sheets("Productos")
  28. LR3 = .Range("A" & .Rows.Count).End(xlUp).Row
  29.  
  30. For i3 = LR3 To 2 Step -1
  31. If Not IsNumeric(.Range("A" & i3).Value) Or _
  32. .Range("A" & i3).Value = "" Then .Rows(i3).Delete
  33. Next i3
  34. End With
  35. End Sub
  36.  
  37. Dim LR3 As Long, i3 As Long
  38.  
  39. With Sheets("Productos")
  40. LR3 = .Range("A" & .Rows.Count).End(xlUp).Row
  41.  
  42. For i3 = LR3 To 2 Step -1
  43. If IsNumeric(.Range("A" & i3).Value) And _
  44. len(.Range("A" & i3).Value) > 0 Then
  45.  
  46. Else
  47. .Rows(i3).Delete
  48. End If
  49. Next i3
  50. End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement