Similar codes

Card image cap
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Card image cap
FindIn1DArray

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

2018Jun6

Card image cap
SplitTo2DArray

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

2018Jul9

Card image cap
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

Card image cap
HasDups

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

2019Oct5

Card image cap
CalcArea

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

2018Jul24

Card image cap
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

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
Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Card image cap
ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

2018Jul22

Card image cap
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

Card image cap
RandBetween

Generating random number between two

2018Apr25