After hours of googling, I am still baffled about what seems like it should be a relatively simple fix. Please tell me why my code is not working and how to fix it. My best guess currently is that I am not correctly escaping special regex characters. The actual workbook contains sensitive data, but I've attached a simple sample that operates the same way.
Thank you to whoever solves this. It has been quite the headache.
Please Login or Register to view this content.
Last edited by k64; 03-21-2014 at 11:23 AM. Reason: New Sample
See if this is how you wanted.
Please Login or Register to view this content.
Thank you! That is farther than I got. I need it to be a little more flexible, because there are a couple types of formulas that include "RBC mmm YY". My goal is to simply replace each specific "RBC mmm YY" with an indirect version. I've provided another sample with a couple of different cases.
I'm new to Regex. Would you mind telling me what the problem was and how you fixed it?
Thank you
If further question, it will be tomorrow.
Please Login or Register to view this content.
Thank you! It took a little modification, but that did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks