Dr. Demento
Well-known Member
- Joined
- Nov 2, 2010
- Messages
- 618
- Office Version
- 2019
- 2016
- Platform
- Windows
I'm trying to adapt a function that currently uses Range.Characters and replace it with something that can be done in array. I had some ideas but it doesn't appear they were feasible. I did have one thought that I think is doable but I need some direction.
I pose my myriad of questions here but for this post, I'm only concerned with one option. I suggest identifying each non-matching character within a string array, tag the non-matching character with a delimiter of some type (CHAR 166), and then do a Find/Replace of all of the delimiter (change font color/bold the single character after the delimiter and then delete the delimiter).
My question is: Is there a fast way to Range.Find/Replace or MATCH or SUBSTITUTE in the Range domain of changing the font color/bold the single character AFTER the delimiter and then delete the delimiter?? Stated another way, I'm interested in identifying and manipulating the character after the delimiter.
Thoughts??
Thanks y'all
I pose my myriad of questions here but for this post, I'm only concerned with one option. I suggest identifying each non-matching character within a string array, tag the non-matching character with a delimiter of some type (CHAR 166), and then do a Find/Replace of all of the delimiter (change font color/bold the single character after the delimiter and then delete the delimiter).
My question is: Is there a fast way to Range.Find/Replace or MATCH or SUBSTITUTE in the Range domain of changing the font color/bold the single character AFTER the delimiter and then delete the delimiter?? Stated another way, I'm interested in identifying and manipulating the character after the delimiter.
Thoughts??
Thanks y'all