OK, here is a macro that may do what you want. http://members.optusnet.com.au/~alli...changeref2.zip
EDIT: I just realised that you probably want to change the formulae in their original location. I have changed the macro to do this. Let me know if it works as you had hoped.
Matt
Bookmarks