Code:
Sub Ent1_S_S()
If Range("CT73").Value + Range("CT74").Value = 0 And Range("CU73").Value + Range("CU74").Value = 0 Then
Range("CT85").Value = Range("CS73").Value
Else
Range("CT85").Value = "No"
End If
End Sub
I want to adapt this code to continuously look for the situation where: Range("CT73").Value + Range("CT74").Value = 0 And Range("CU73").Value + Range("CU74").Value = 0
When it finds this to be true, and enters the value of CS73 into CT85, I want this new value in CT85 to be fixed and the code to stop running. Can anyone help?
Last edited: