Search results 63

  2. Search results
  3. array
Sorted from new to old.
Card image
XMLRead

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

2023Nov26
Card image
End ( xlDown )

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

2023Aug28
Card image
FilesIn_Array and FoldersIn_Array

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

2023Aug15
Card image
Arr_1Dim_2Str

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

2023Aug14
Card image
Range22DimArray

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

2023May11
Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23
Card image
ArrSort_4Arr

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

2023Apr14
Card image
LstCustomSelection_Refresh

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

2022Aug31
Card image
ArrSort_3Arr

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

2022Jul24
Card image
Range2ANStr

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

2022Jul19
Card image
RemoveDuplicates

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

2022Jul7
Card image
DBTables

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

2022Apr28
Card image
BooleanCount

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

2022Apr22
Card image
Subtotal_Indirects

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

2021Nov26
Card image
CleanArray

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

2021Sep22
Card image
merge2Arrays

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

2021Sep21
1234