Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

Subtotal_Indirects

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

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

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

JSON-VBA.zip

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option