Code:
For i = 0 To 12
If Range("SetsP1").Value + Range("SetsP2").Value = 0 And Range("GamesP1").Value + Range("GamesP2").Value = i Then
Range("CT" & (85 + i)).Value = Server
End If
Next i
This code is looking up Named Ranges and outputting values into referenced cells. Problem is, I am planning on moving the information on the spreadsheet and although the named ranges will follow the information, the code referencing cells will not. How do you write code for a cell reference that will move with the cell it's referencing if the cell is moved?