Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look for a value and clear it
I'm trying to find anything in column 9 that = "-//200-" and clear it.
Why does this not work? iEnd = ws.Cells(65536, 9).End(xlUp).Row Set rng = ws.Range(ws.Cells(3, 9), Cells(iEnd, 9)) For Each c In rng If InStr(c, "-//200-") = False Then c.Clear Next c Thanks, -- Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
Why Doesn't it Clear?? | Excel Discussion (Misc queries) | |||
clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
Not clear | Excel Discussion (Misc queries) | |||
Is there any way we cna clear everything.. | Excel Programming |