Thanks, that works great.
In answer to the first question, yes, its offset to the right.
How could I include to lock the cell in this code.
I already protect the sheet under another code so dont need to worry about
that.

"Test" wrote:

If ActiveCell.Offset(0, 4).Value = "Mech" Then
ActiveCell.Offset(0, 10).ClearContents
End If