Returns array of values by an XML expression from XML file. Xmlfilepath is the ...
A bug found because of using End(xlDown) Please stop using Range("A1"). ...
Return list of files in a folder back as array. Similar to
Converts 1-dimension array into text. Meet Join. A way to convert array into ...
Imports a range into 2-dimension array. Returns the array, providing range, ...
2 functions to sort 5 Arrays or 7 Arrays respectively.
Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...
Read list of items from Settings sheet, then Sort, then save, before reading ...
Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...
Converts sheet range to ANString, can work on any continued range, 1 or 2 ...
Removes duplicated items from a 1-dim array into new array, does not modify ...
Returns an array of all table names in a database. needs valid OLE database ...
Counts how many values are True (or anything) in an array of boolean values ...
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
Cleans array of unwanted items This usually needed after you merge two arrays, ...
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
50 chars max.