This post is similar to my post from yesterday about replacing references to
named ranges with their respective addresses, but now I have a different
question.

While using Jan Karel Pieterse's Name Manager, I found that it was able to
rename Named Ranges and replace references to them in cell formulae.

It was also able to replace references to that range. For example, I had
ranges named "i" and "int_x" and a cell containing the formula
"=sum(i,int_x)". When I told Name Manager to rename "i" to "go", it replaced
the stand-alone "i" in the formula and NOT the "i" in "int_x".

Is there some method that simplifies this task? I was trying to using
string functions to replace the "i" with "go", but that resulted in "gont_x".
Is there a method of looking in a cell's formula and finding the references,
similiar to how we look at a formula in the formula bar and see the
references' text colored and their cells highlighted?

My overall goal is to write a routine that removes all named ranges from a
workbook and replaces all references with the named range's address.

Thanks,
Pflugs