Hello,
I have two arrays. One is the "Find" array, the other is the "replace" array. They are replacing values in specific columns on another sheet in the same workbook. Both these arrays are driven by formulas. I have a super long program written that goes through and replaces each value in each specific column, but it keeps failing. Can anyone help with the code for this? I have a hunch my original code would be useless, so I haven't included it. I've posted the table with the find and replace arrays, and the specific columns they will be finding and replacing on in the other sheet.
find_replace.JPG
Thank you in advance.
Bookmarks