Open Question: Find and replace macro help please!?




   I would like to make an Excel macro which uses find and replace to find a a text string with a variable or result of a furmula in a cell reference. I tried recording a macro to do it, but could only get it to replace with the text, not the reult of the reference/formula. Please help.





http://uk.answers.yahoo.com/question/index?qid=20100202154340AAaWDbc