Random codes

Similar codes

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

2019Oct20

ANmarAmdeen

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

ANmarAmdeen

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

ANmarAmdeen

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

ANmarAmdeen

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

ANmarAmdeen

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

Jun30

ANmarAmdeen

Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

2018Apr25

ANmarAmdeen

MultiRead_JSON

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

Jan13

ANmarAmdeen

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ANmarAmdeen

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

ANmarAmdeen

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

ANmarAmdeen

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

ANmarAmdeen

RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

2018Sep5

ANmarAmdeen

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

ANmarAmdeen

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

ANmarAmdeen