I want to replace cells from column F to S with zero(0), with a condition IF cells are >0.
how do you use replace function with that condition?
I tried doing:
[VBA]Sub f()
ActiveSheet.UsedRange.Replace >0, "", xlWhole
End Sub[/VBA]
But it just reds out.
Thanks!