I am working with files with defined range names. These name ranges refer to
on cell only. I want to change all formulae in the file: change range name
back to cell reference (so I can delete the range names).

E.g. cell $A$42 is called range "ip_con" - there is a formula in cell b99
that says "=ip_con +200". I want the formula to say "=$A$42+200".
Obviously, there are a lot of these references, so looking them by manually
is NOT an option.

Any help would be appreciated!!!!