hi everyone i am new to this fourms site and just wanted to say hi first
my issue is simple, anything with a value of 0.00 in column H i want the entire row to be deleted.
i thought i solved the issue but with my current code, but anything from 0.00 to 0.09 gets deleted. i just need 0 aka 0.00.
take a look please
Sub zerout()
'THIS DELETES ALL ROWS WHERE THE VALUE IN COLUMN H IS "0.00"
Dim FoundCell As Range
Application.ScreenUpdating = False
Set FoundCell = Range("H:H").Find(what:="0")
Do Until FoundCell Is Nothing
FoundCell.EntireRow.Delete
Set FoundCell = Range("H:H").FindNext
Loop
End Sub
[table="width: 500"]
can someone please help me out.. the end result is this: delete rows that have a value or 0.00 in column H. if it matters column H is formatted with a number value.
Bookmarks