I'm trying to replace the last letter in column A with out replacing any other letter using VBA.
Example - I'm trying to replace the last letter which is "A" in column A to be "B" with out changing any other letters
Column A
<colgroup><col></colgroup><tbody>
TAD106A
TAD107A
TAD108A...