I have a workbook with multiple worksheets. In worksheet 1, I have 2 columns of text strings. I want to use the data in column A in a "find" and substitute the value in the corresponding row of column B into the "replace" function. I want to find and replace across the entire workbook (all sheets). I know this is simple but I am rusty on my VBA.
Cheers,
Craig
Bookmarks