Recent codes added Codes added recently by our developers. 16 most recent codes.

Card image cap
SettingSave + SettingRead for NumberFormat

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

Card image cap
ANmaCellFormat

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

Card image cap
CopyFields_FromTo

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

Card image cap
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Card image cap
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image cap
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image cap
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Card image cap
OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

Card image cap
Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Card image cap
Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Card image cap
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Card image cap
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image cap
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...