Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-10-2020, 10:25 AM
pushpi004 pushpi004 is offline Case sensitivity not followed when using replace method. Windows 10 Case sensitivity not followed when using replace method. Office 2016
Novice
Case sensitivity not followed when using replace method.
 
Join Date: Feb 2020
Posts: 21
pushpi004 is on a distinguished road
Default Case sensitivity not followed when using replace method.

Hi all..
I hope all are doing well..
I have been trying to develop a small macro which could find certain words from a PowerPoint presentation and replace them with certain other words using the method TextRange.Replace(FindWhat:=FindString, _
Replacewhat:=ReplaceString, WholeWords:=True, MatchCase := False)

The requirement is that the ReplaceString should have the same case sensitivity as that of the words to be replaced in the presentation. But using the above method, the case of the ReplaceString always remains the same( as defined earlier). I need it to change it as per the case of the FindString from the presentation.

For example, if my FindString is bridge and ReplaceString is brg, in my presentation, if Bridge comes up, it should be replaced with Brg ( but with above method, it is replacing Bridge with brg)


I hope my query has made some sense..

Can anyone please help me with this?



Thanks
Regards

Last edited by pushpi004; 10-10-2020 at 10:35 AM. Reason: Providing example for better understanding
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Case sensitivity not followed when using replace method. Title case macro gets a "type mismatch" error at the Instr method marceepoo Word VBA 1 03-05-2020 09:41 PM
Drawing Guides Sensitivity Setting? Slidemaker PowerPoint 2 05-18-2017 12:45 PM
Using wildcards in Find/Replace to change font/case angie450 Word 2 05-26-2016 11:09 AM
Case sensitivity not followed when using replace method. Find and replace with a macro, problem with letter case garcanrya Word VBA 2 01-10-2014 05:40 AM
Replace & case Jennifer Murphy Word 1 02-11-2013 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft