I use the below macro (thanks Dave Peterson) to format specific words in a range of Excel cells.
I would like to make the search terms (myWords) case insensitive and I've tried using MatchCase, but apparently I'm using it incorrectly or in the wrong place.
Can someone help?
Please Login or Register to view this content.
Maybe try swapping:
ForPlease Login or Register to view this content.
Please Login or Register to view this content.
The Find method is case insensitive by default so your macro should work "as-is". Can you attach a sample so we can see why it's not working?
WBD
Office 365 on Windows 11, looking for ✶ rep!
Please Login or Register to view this content.
From what i have found, if you do not declare case sensitive part within the Find statement then VBA Find will default to whatever the last manual options were. If your last manual Find was case sensitive then your next VBA Find will be unless you declare otherwise.
This is why i have included the True in the case sensitive part of the Find.
Please Login or Register to view this content.
Find's case sensitivity is also dependent on any other finds that have been done in the current session of Excel. However, you also need to alter this part:
to something like:Please Login or Register to view this content.
Please Login or Register to view this content.
Rory
I made a couple of tweaks:
WBDPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks