Thread
:
Look for a value and clear it
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dan R.
external usenet poster
Posts: 220
Look for a value and clear it
oops, that should be:
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-") = True Then c.Clear
Next c
Reply With Quote
Dan R.
View Public Profile
Find all posts by Dan R.
Look for a value and clear it