How to find values between a range and delete
Solved/Closed
Hello,
I don't know where to begin in writing this macro. If i have column J with values & I want to search for any values BETWEEN ranges of 1.00E+17 to 1.00E+38 and delete rows when it finds those values.
Thanks
Irene
I don't know where to begin in writing this macro. If i have column J with values & I want to search for any values BETWEEN ranges of 1.00E+17 to 1.00E+38 and delete rows when it finds those values.
Thanks
Irene
Related:
- How to find values between a range and delete
- How to delete whatsapp account without login - Guide
- How to delete whatsapp account without phone - Guide
- How to delete part of a table in word - Guide
- How to delete icloud tabs - Guide
- How to delete badoo account - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 21, 2010 at 09:51 AM
Sep 21, 2010 at 09:51 AM
Hi Irene,
Try this macro:
You might want to change the range and replace the < and > symbols by <= and >=.
Best regards,
Trowa
Try this macro:
Sub test()
Set MyRng = Range("A1:A20")
For Each cell In MyRng
If cell.Value > 1E+17 And cell.Value < 1E+38 Then
cell.EntireRow.Delete
End If
Next
End Sub
You might want to change the range and replace the < and > symbols by <= and >=.
Best regards,
Trowa
