Hello Everyone,
I have some code that is not working and I'm not sure why... I have a worksheet that has a list of values, however, some values I'd like to replace. Therefore, on another sheet, I made a table that contains the values and their replacements. In order to replace the values, I created a vlookup function and a substitute public sub. Here is the code:
I've attached a test workbook so you can see that some of the values will not change. I'm sure it has something to do with changing them from general format to text.
Thanks in advance!
TestBook3.xlsm
Bookmarks