Similar codes

Card image cap
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

Card image cap
CalcArea

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

2018Jul24

Card image cap
CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

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

Card image cap
Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

2019Dec31

Card image cap
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

May11

Recently by developer

Card image cap
ANString_Location

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

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Random Codes

Card image cap
Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

Jul30

Card image cap
jQuery Store Locator

Google Maps API implementation using jQuery and json From

2019Jul1

Card image cap
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11