I have tried to write code to clear values from 0 to 0.01 in Col F from row 2 onwards
The macro clearing all data in the same row as where 0 to 0.01 in in Col F
![]()
Sub Clear_smallItems() With Sheets("Imported data") LR = Cells(.Rows.Count, "F").End(xlUp).Row For i = LR To 2 Step -1 If (((.Cells(i, 6).Value) >= 0)) And ((.Cells(i, 6).Value) <= 0.01) Then .Rows(i).ClearContents Next i End With End Sub
It would be appreciated if someone could amend my code
Bookmarks