Random codes

Similar codes

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

ANmarAmdeen

MinOfArray

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

2019Oct20

ANmarAmdeen

MaxOfArray

Gets the maximum number from an array. Like

Oct24

ANmarAmdeen

ChartMaxY + ChartMinY

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

2018Aug16

ANmarAmdeen

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

ANmarAmdeen

LXFormat

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

2023Jun30

ANmarAmdeen

Floor

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

2018Apr25

ANmarAmdeen

VBInstr_Numeric

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

Feb25

ANmarAmdeen

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ANmarAmdeen

Recently by developer

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

ANmarAmdeen

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

ANmarAmdeen

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

ANmarAmdeen

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

ANmarAmdeen

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

ANmarAmdeen

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ANmarAmdeen

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

2019Jun2

ANmarAmdeen

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

ANmarAmdeen