I am attempting to search and replace a value within a specific range in a worksheet. I do not want to replace the value in other places in the worksheet. I've tried the following two vba options. In both cases the code is replacing the values in columns J & N with "1A". So, when the code...