How would I write VBA code to do the following:
IF "P1" is evident in Range CX85:CX94 Then
Return "Place..." in CN73
[table="width: 500"]
[tr]
[td]If Application.CountIf(Range("CX85:CX94"), "P1") Then Range("CN73").Value = "Place..."[/td]
[/tr]
[/table]