Search results 44

Sorted from new to old.
Card image
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

Card image
ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

Card image
Range2ANStr

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

Card image
RemoveDuplicates

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

Card image
DBTables

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

Card image
BooleanCount

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

Card image
Subtotal_Indirects

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

Card image
CleanArray

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

Card image
merge2Arrays

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

Card image
SortedFiles

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

Card image
JSON-VBA

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

Card image
ANSQLWherein

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

Card image
Max + Min

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

Card image
MinOfArray

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

Card image
HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

Card image
jExcel

jQuery plugin to embed a spreadsheet, compatible with Excel, in your browser. ...