Hi all-
I've got some excel code that does a search & replace through a number
of files. it has a list of values & new values to replace those with,
then it opens one of the files, and iterates though the list of
replacements. once it's done cycling through the list of replacements,
it closes the open file and opens a new one, starting the cycle again.
this all works fine.

What doesn't work fine is: I can't seem to get it to tell me correctly
whether it found anything with the replace. some of the files won't
have any replacements within. I'd like to keep a list of which files
got replacements (just a count would be fine) and which didn't.

I've tried many variations on the following
y= range.replace("old","new")

no matter what, y returns True, whether it made a replacement or not.

I suppose I could do an Instr() first and then do the replacement if
instr() is not 0 then increment the counter but I'd like to figure out
why the Replace() keeps returning True.

TIA,
Tim
tjw@fadavis.com