R
Roger
Hello,
I’m looking to run this on the noted row after entries have been made. Only
problem is – it doesn’t work.
Can you tell me what I’m doing wrong? I’m 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
I’m looking to run this on the noted row after entries have been made. Only
problem is – it doesn’t work.
Can you tell me what I’m doing wrong? I’m 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