Search results 104

Sorted from new to old.
Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Card image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Card image
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Card image
Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Card image
Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Card image
Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

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
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...