hi.
For a specific range of cells that I define, I would like to search for a particular piece of text within the formula - if found, paste values and then move on to the next.
Specifically, I'm trying to paste values for all vlookup formulas in a range of cells in a worksheet.
Can someone help...