Hello,
I am trying to write a macro to replace all cells in column E with a value less than 1 to zero. I have to following macro but it does not work. Any suggestions? Thank you!
Thanks,Sub Replace_w_0() Dim rng As Range For Each rng In Range("e:e") If rng.Value < 1 Then rng = 0 End If Next rng End Sub
Laura
Bookmarks