Find and Replace - quantum of replaces

Hi All,

till now, i am using this macro

Please Login or Register  to view this content.

i have these replaces very, very much after a time and it is very confusing, because i dont have very good control over same words etc.
You know, the replaces needs some logic so i have made "categories" of replaces. But now i d like to move on and question you if there is some better solution, in which i will be more able to read the code and know where i have to put some new replace strings.


I think the best choice should be to take the find and replace strings in sheet named "replaces" for example and the routine will go row by row until empty row and in A column will be search strings, in B column replace strings. After null row, i would be happy if the string will start also at C (find string) and D column (replace string) etc. This last thing is about more categories for search... i like to have these separated by my logic. So after the routine will not find value in A, x or C, x or D, x etc, than script ends.

I added the example sheet.findReplace.xlsx

I will be very happy, if the script will do the routine on SELECTION and with values as above (i just copied it bellow)

Please Login or Register  to view this content.

-----------------------------
Also i have one question and it is if there will be some limitation. Because i have found out, that previous macro had limitations so i had to do more procedures (modules)