Hello
I would like to include 2 patterns in one function, e.g.
What's the best way to do it?Please Login or Register to view this content.
Many thanks
Nic
Hello
I would like to include 2 patterns in one function, e.g.
What's the best way to do it?Please Login or Register to view this content.
Many thanks
Nic
Last edited by Niclal; 06-29-2022 at 03:21 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
You must use code tags when posting code - please edit your original post and do this. For your problem, you can use the RegEx "or" operator of pipe:
WBDPlease Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
@WideBoyDixon I have not tested this but wouldn't you have to put parens around each entire expression to the left and right of the pipe?
Otherwise I think the pipe will just apply to the expressions immediately to the left and rightPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks