Originally Posted by macropod

You could use the macro recorder to record such a Find/Replace, then add the relevant portions of the recorded code to your existing sub. There are also plenty of posts in this forum showing the use of Find/Replace in macros.