The code in https://www.msofficeforums.com/word-...d-replace.html has been really helpful to me. But I am facing difficulty in case of case sensitivity. The word gets replaced only if it matches the case. The lengthier solution to this problem is having the word with all possible cases (e.g. all caps, or all small or capitalising each word) in the worksheet. Can we do any modification to this code, so that the words gets replaced even if their case did not match and the replaced word remains in same case as the word being replace (like when we do it with MS word's replace function)?, if so, please help me with this.
Thanks
Regards