Random codes

Random 24 Codes by our developers.

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

Toggle5Values

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

Feb2

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

ANBSThumbImg + ANBSThumbLink

Creates thumb of an image with or without link to original Use ANBSThumbLink ...

2019Dec1

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

FindIn1DArray

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

2018Jun6

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

Flexselect

Flexible select dropdown in jQuery From

2019Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

GetRandom

Generate random string, fully customization, with even deciding what special ...

2018Apr21

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

FilesCount_Swift

Count how many files in a folder, with no loop, faster if you just need all ...

2019Feb2

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14