This is a snippet of code where I have recently adapted some of the cells to Named Ranges and I think it might be upsetting the code as the code isn't working.
The code used to be as below and worked fine.
Code:
For i = 0 To 9
If Range("SetP1").Value + Range("SetP2").Value = 0 And Range("GaP1").Value + Range("GaP2").Value = i Then
Range("CT" & (85 + i)).Value = Server
End If
Next i
The code used to be as below and worked fine.
Code:
For i = 0 To 9
If Range("CT73").Value + Range("CT74").Value = 0 And Range("CU73").Value + Range("CU74").Value = i Then
Range("CT" & (85 + i)).Value = Server
End If
Next i
Last edited: