How can I use a cell address in a formula within a range loop?
I've tried the below but it doesn't work;
For Each cell In Range("B3:B18")
If cell.Value <> 0 Then
cell.Offset(0, 1).Formula = "=IF(Cell="""","""",COUNTIF(DEPLOYMENTS!$S$2:$S10000,Cell))"
End If
Next