Search results 81

Sorted from new to old.
Card image
MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Card image
Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Card image
ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

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
ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

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
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
ArrSort_3Arr

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