Search results 47

Sorted from new to old.

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

LstCustomSelection_Refresh

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

2022Aug31

ArrSort_3Arr

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

2022Jul24

Range2ANStr

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

2022Jul19

RemoveDuplicates

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

2022Jul7

DBTables

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

2022Apr28

BooleanCount

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

2022Apr22

Subtotal_Indirects

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

2021Nov26

CleanArray

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

2021Sep22

merge2Arrays

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

2021Sep21

SortedFiles

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

2020Aug11

JSON-VBA

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

2020Jul30

ANSQLWherein

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

2020Jan6

Max + Min

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

2019Dec31

1 2 3