MatchIF5

Searching for rows having 5 values in 5 columns Like

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

ListBox bug with TabIndex

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

CopyFiles Excel-Macro

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

CopyFiles.zip

OneDrive Reset

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

DateDateDate

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

NumberNumberNumber

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

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...