Hello from Steved In VBA how do I please remove ' from Louise's Gold to leave Louises Gold Thankyou.
S Steved Apr 24, 2005 #1 Hello from Steved In VBA how do I please remove ' from Louise's Gold to leave Louises Gold Thankyou.
S Shauna Kelly Apr 24, 2005 #2 Hi Steved With ActiveDocument.Range.Find .ClearFormatting .Replacement.ClearFormatting .Text = "Louise's Gold" .Replacement.Text = "Louises Gold" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .Execute Replace:=wdReplaceAll End With Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word
Hi Steved With ActiveDocument.Range.Find .ClearFormatting .Replacement.ClearFormatting .Text = "Louise's Gold" .Replacement.Text = "Louises Gold" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .Execute Replace:=wdReplaceAll End With Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word
S Steved Apr 24, 2005 #3 Yes It helped Thankyou. Shauna Kelly said: Hi Steved With ActiveDocument.Range.Find .ClearFormatting .Replacement.ClearFormatting .Text = "Louise's Gold" .Replacement.Text = "Louises Gold" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .Execute Replace:=wdReplaceAll End With Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word Click to expand...
Yes It helped Thankyou. Shauna Kelly said: Hi Steved With ActiveDocument.Range.Find .ClearFormatting .Replacement.ClearFormatting .Text = "Louise's Gold" .Replacement.Text = "Louises Gold" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .Execute Replace:=wdReplaceAll End With Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word Click to expand...
