Étiquette : vba
-
Excel VBA Question – How can I optimize this code?
I’m trying to create a function in Excel, where the user will be able to extract some data using regular expression. I’ve manage to create a nice function. However, there is a performance issue. When the user copy my function over 50 000 lines, Excel takes about 1.5 minutes to update all the values. Here…