Search results 104

Sorted from new to old.

Choose2

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

2024Aug20

ANmaSearch_OrFriends

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

2024Jul30

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

Min_No0s

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

2024Jun5

SortArea4

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

2024Apr15

Send workbook as email attachment

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

2024Feb14

Converts two bytes to long

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

2024Jan14

MultiRead_JSON

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

2024Jan13

Grandchildren files and count

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

2024Jan11

ANStringListRead_JSON

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

2024Jan9

ReverseArray

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

2023Nov27

XMLRead

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

2023Nov26

End ( xlDown )

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

2023Aug28

FilesIn_Array and FoldersIn_Array

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

2023Aug15

Arr_1Dim_2Str

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

2023Aug14

SubZero

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

2023May23

1 2 ...6 7