MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

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 ...

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

1FileDB

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

1FileDB.zip

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

GoToInternet

Opens webpage from within Excel, using default browser