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 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