Javascript regex: extract single number from string The Javascript regex function below extracts a single number from a string (including decimal...Read More
VBA base64: encode and decode string in base64 Use the functions Base64EncodeString and Base64DecodeString in the code module below to encode and...Read More
VBA Excel string functions: sanitize sheet name Microsoft Excel does not allow certain special characters in sheet names and the length...Read More
VBA Outlook functions: check if email account exists in Microsoft Outlook Checks whether the specified email account exists in Microsoft Outlook. Requires Microsoft Office 2007...Read More
VBA Outlook functions: check if Microsoft Outlook is open Checks whether Microsoft Outlook is open. Requires Microsoft Office 2007 or newer. Returns true...Read More
VBA regex functions: validate email address A very effective VBA regex function that even accepts plus addressing (plus sign included...Read More
VBA sorting: InsertionSort If your data to be sorted is always nearly sorted already then you probably...Read More
VBA sorting: ReverseSort The function below reverses the order of the values in a one-dimensional array. Does...Read More
VBA Excel find functions: find all cells in range or worksheet that contain a specific value The function below returns a (non-contiguous) range object containing all the cells in a...Read More
