Change: i = Target.Row to: i = Target.Row if i < 2 Then Exit Sub if your data starts on the second row
i = Target.Row
i = Target.Row if i < 2 Then Exit Sub
Forum Rules