Hi, could anyone tell me what I did wrong here? Macro's not working. Thank you.
(I want to replace one of two duplicates with "0")
Dim rng As Range, cell As Range
Set rng = Range("e3:e208")
For Each cell In rng
If ActiveCell.Value = ActiveCell.Offset(0, 1).Value Then
ActiveCell.Offset(0, 1).Value = "0"