CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

ANString_Location

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

SettingSave + SettingRead for NumberFormat

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

ANmaCellFormat

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

CopyFields_FromTo

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

ListBox bug with TabIndex

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

MatchIfUp or MatchIfRev

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

ContainerHTMLTag_ReturnBlock

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

Concatenate_HTMLColumn

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

CopyFiles Excel-Macro

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

CopyFiles.zip