Dear Friends,
I have created the macro for replacing the one word with another word. for example "N" with "S" and "S" with "R" etc (which is present in the sheet)
This replace value is taken from the table
what my problem is when macro executes it replace the "N" with "S" and again then "S" with "R" so, ultimately it replaces "N" with "R", which i want to avoid
if once it is replaced then i want to avoid replacing second time
How can i do this?