Search results 64

Sorted from new to old.
Card image
ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

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