Hi All,
I am trying to find a way to VBA what the Excel 2010 Find and Replace performs.
I can select the range that I want to have the replacements made using Range.("My Range").Select - no problems
I do want the FIND information to be from a specific cell named "FINDTHIS" and the REPLACE WITH information to be from a specific cell named "REPLACEWITHTHIS".
The information in the two named cells changes based on other cells in the worksheet. Further, the information in these two cells are not a formulas but rather strings.
I have tried the macro recorder copying in the cells during the recording process but the macro hard codes the data for the FIND and REPLACE text with whatever text you are using at the time of the recording and skips the copying in process.
Any ideas?
Bookmarks