Apply validation on two cells, when a 3rd cell is changed When modifying a ...
2020May27
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Creates list of unique items found in a column, returns string with items ...
2020May6
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Show list of items with their description from "Settings" sheet Have that list ...
2018May17
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Allow users to select from list box based on search terms. Have a text box and ...
2018Jun7
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Counts how many cells with data in a row, starting from certain column until ...
Sat 11AM
Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...
Jun10
An attempt to read json into table. This one is a work in progress, tested and ...
Jun6
Finally, can have one command to open any file using its default associated app ...
2022Jan28
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17