Cells.Replace need to keep track of result
Hello all,
Solved my problem. I used .Find for the counter.
Thanks,
Sriram
"Sriram" wrote in message
...
Well just figured out that Cells.Replace always returns TRUE. So, is
there
a way to track the number of times a 'find & replace' is successfull (ie.
number of replacements made)?
Thanks,
Sriram
"Sriram" wrote in message
...
Hello all,
Quick question. I need to keep track of whether or not the
Cells.Replace
is
successful in finding and replacing. I've created a Boolean variable
(isfound) and set it to the Cells.Replace and an integer (found_count)
for
the counter but it (isfound) keeps returning 'True' even though the
'What:=lookup_val' I know didn't find anything.
Secondly I need to take the found_count and display this value using a
dialogue box. Is this possible if so can anyone provide an example.
code snip (xl2k):
Dim found_count As Integer
Dim isfound As Boolean
isfound = repl_wks.Cells.Replace(What:=lookup_val,
Replacement:=repl_val,
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False)
If isfound = True Then
found_count = found_count + 1
End If
Thanks,
Sriram
|