Similar codes

Card image cap
MinOfArray

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

2019Oct20

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
CalcArea

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

2018Jul24

Card image cap
VBInstr_Numeric

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

Feb25

Card image cap
ChartMaxY + ChartMinY

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

2018Aug16

Card image cap
LXFormat

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

Jun30

Card image cap
Floor

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

2018Apr25

Card image cap
MultiRead_JSON

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

Jan13

Card image cap
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

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

Apr23

Random Codes

Card image cap
New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

Card image cap
Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

Card image cap
IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23