Regular expressions
Excel » VBA » Regular expressions »
Count matching strings using regular expressions
A regular expression is a pattern containing specific characters to search for sub-strings in strings. The patterns are at first […]
Fetching values from ThingSpeak using vba
Thingspeak is web service that allows you to upload and store data from IoT devices. Picture above shows cheap chinese […]
Extract cell references from a formula
I am trying to build a regular expression that matches cell references in a formula. A regular expression is a […]
Working with the LIKE OPERATOR
The LIKE operator allows you to match a string to a pattern in excel vba. The following characters are specifically […]