Home Sum syntax for IF condition in Loop
 Hoping this is an easy answer. Sorry if a dumb question, but I'm trying to figure out the right syntanx for this if statement. I want THEN triggered if the entire row sum is the value of the active cell. How can I correct my code? Code was working until I added the last OR assessment Or Sum(Rng2.EntireRow) = Rng2.Value For Each Rng2 In WorkRng2 If Rng2.Value = 0 Or Rng2.Value = "" Or Rng2.Offset(0, 3).Value = "Define" Or Sum(Rng2.EntireRow) = Rng2.Value Then Rng2.Value = Rng2.Offset(-1, 0).Value End If Next