VBA File Picker: msoFileDialogOpen Use the function below to display a file picker window and let the user...Read More
VBA array functions: find value in array Array function to find a particular value in either a one-dimensional or multi-dimensional array....Read More
VBA date functions: test if date intersects date range A simple and elegant function to test whether a specific date is equal to...Read More
Javascript regex: validate email address A very effective Javascript regex function that even accepts plus addressing (plus sign included...Read More
VBA Excel find functions: last row in worksheet or range By far the easiest and most reliable function to find the highest row number,...Read More
VBA Sorting: QuickSort A VBA implementation of Tony Hoare’s famous recursive divide-and-conquer sorting algorithm from 1959. The...Read More
VBA Folder Picker: msoFileDialogFolderPicker The functions below let the user pick a folder in the local file system...Read More
