Search results 63

Sorted from new to old.
Card image
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
Range22DimArray

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

Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
ArrSort_4Arr

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

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