Guys help,
Instead of giving me a whole number as in the row number I am getting a number to 3 decimal places. What is wrong with the below code?
Dim MyRange As Range, MyCell As Range Dim LRow as Long ' Delete entire row if Profit is greater than 0 LRow = ThisWorkbook.Sheets(3).Range("G" & Rows.Count).End(xlUp).row Set MyRange = ThisWorkbook.Sheets(3).Range("G2:G" & LRow) For Each MyCell In MyRange If MyCell.Value <> "" And MyCell.Value > 0 Then Rows(MyCell).EntireRow.Delete Else Next MyCell
Bookmarks