Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reposting - Why would this not Clear Cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reposting for help with Outlook from Excel | Excel Discussion (Misc queries) | |||
Cells.Clear | Excel Discussion (Misc queries) | |||
Sorry for reposting - but this is driving me crazy! | Excel Discussion (Misc queries) | |||
Clear Cells | Excel Discussion (Misc queries) |