You have a couple of replies to your first post.

Roger wrote:

Hello,

Im looking to run this on the noted row after entries have been made. Only
problem is €“ it doesnt work.

Can you tell me what Im doing wrong? Im just trying to clear a cell if it
has the value €œNo€� in the cell.

Thank you - Roger

Sub NoNo()
For Each c In Worksheets("Front Page").Range("F15:F60").Cells
If c.Value =€�No" Then c.Selection.ClearContents = True
Next
End sub

--

Dave Peterson