Random codes

Similar codes

CalcArea

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

2018Jul24

ANmarAmdeen

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

ANmarAmdeen

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

ANmarAmdeen

SplitTo2DArray

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

2018Jul9

ANmarAmdeen

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

ANmarAmdeen

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

ANmarAmdeen

ReverseArray

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

Nov27

ANmarAmdeen

CountArrayCol

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

2019Aug9

ANmarAmdeen

ANStringListRead_JSON

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

Jan9

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

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

ANmarAmdeen

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

ANmarAmdeen

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

ANmarAmdeen

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

ANmarAmdeen