Hi,
Mind's gone blank. Can someone remind me how I would write this:
So that the highlighted part always references the last cell based on the LR?
Thanks,
Matty
Mind's gone blank. Can someone remind me how I would write this:
Code:
For i = 2 To LR
With .Range("A" & i)
.Formula = "=COUNTIF(RC[2]:[COLOR=#ff0000]R4913C[2][/COLOR],RC[2])"
.Value = .Value
End With
Next i
So that the highlighted part always references the last cell based on the LR?
Thanks,
Matty