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

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Subtotal_Indirects

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

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, ...

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...