RegEx-implemation not working on Mac/Office11 (RegexExample.xlsm)?

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
44 views
0

Excel Regex Tutorial (Regular Expressions)

Hey Scripters,
i dont have any expirience in Excel, but I do script InDesign. And I need a RegEx in Excel, and found your brilliant guide. Im fiddeling around with another code snippet and yet I dont get any of these to work.
I guess it can have something to do with my crappy MacOS (10.12.6) Office 2011 (v14.7.7 b170905), because I assume your “RegexExample.xlsm” is flawless.

My Excel keeps showing: #VALUE! …where the Output is.

Strange thing is: The Quicklook-Feature from MacOS does show this:
RegEx
Hello
456
5

which should be the real thing.
So, which kind of noobish (Excel-)mistake am I making here?

Simply the best place to learn VBA!