Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...