[solved]-Vba Loop Statements Applied Every Row Row 2 Q39023415

This is VBA. How do I loop all of these if statements so that theyis applied to every row not just row 2?
tions – CONCATENATE3.0xlsm at Debug Run Iools Add-Ins Window Help 4 G CONCATENATE3.0xlsm- Sheet1 (Code) 2Ln 26, Col 1 Worksheet Change Private Sub Worksheet Change (ByVal Target As Range) Range (“B2”).Address Then If Target.Address Range (“C2”) .Value End If If Target. Address Range (“C2”) .Address Then Range (“D2”) .Value End If Range (“D2”).Address Then If Target.Address Range (“E2”) .Value End If Range (“E2”).Address Then If Target.Address Range (“F2”) .Value End If Range (“F2”) .Address Then If Target.Address Range (“G2”) .Value End If I End Sub ole Show transcribed image text tions – CONCATENATE3.0xlsm at Debug Run Iools Add-Ins Window Help 4 G CONCATENATE3.0xlsm- Sheet1 (Code) 2Ln 26, Col 1 Worksheet Change Private Sub Worksheet Change (ByVal Target As Range) Range (“B2”).Address Then If Target.Address Range (“C2”) .Value End If If Target. Address Range (“C2”) .Address Then Range (“D2”) .Value End If Range (“D2”).Address Then If Target.Address Range (“E2”) .Value End If Range (“E2”).Address Then If Target.Address Range (“F2”) .Value End If Range (“F2”) .Address Then If Target.Address Range (“G2”) .Value End If I End Sub ole

Expert Answer

---

Answer to This is VBA. How do I loop all of these if statements so that they is applied to every row not just row 2? … . . .