Vba to clear "Placed" entry once "Suspended" appears

[irishwhiskeycoke]

Hi

I've asked the heldesk but they suggested I ask here

Has anyone the vba code to do the above please?

Thanks

IWC

[probro]

Private Sub Worksheet_Calculate()

If Range("O" & 9).Value = "PLACED" Then

Range("O" & 9).ClearContents
Range("L" & 9).ClearContents

End If

End Sub


Put this code into the worksheet and repeat it with 11, 13, 15 etc.
Change the "PLACED" to any other you want to clear.