Match3

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

Match2

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

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

ANStrRead + ANStrSave + ANStrSearch

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

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

1FileDB.zip

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...