I want to do a macro to use text that is referenced in a cell to find text in a range of formulas and use another cell to replace the found text in that range.
It's easy by hand, but tedious.
I have one cell that displays the text I want to find so I can replace it in the range, "=RIGHT(B3,6)"
I have another cell that displays the text I want to use to replace the found text in that range "=RIGHT(B7,6)"
So, in range B7:B21, find text of "=RIGHT(B3,6)" and Replace with text of "=RIGHT(B7,6)"
I just did a macro to paste the values of "=RIGHT(B3,6)" and "=RIGHT(B7,6)"
Then it would be, In range B7:B21, find text of "F8" and replace with text of "F9"
Thanks!
It's easy by hand, but tedious.
I have one cell that displays the text I want to find so I can replace it in the range, "=RIGHT(B3,6)"
I have another cell that displays the text I want to use to replace the found text in that range "=RIGHT(B7,6)"
So, in range B7:B21, find text of "=RIGHT(B3,6)" and Replace with text of "=RIGHT(B7,6)"
I just did a macro to paste the values of "=RIGHT(B3,6)" and "=RIGHT(B7,6)"
Then it would be, In range B7:B21, find text of "F8" and replace with text of "F9"
Thanks!