VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

Bootstrap table by wenzhixin

Working jquery bootstrap table, with pagination, search, sort and column ...

bootstrap-table-1.13.zip

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

FindFile

Finds if a workbook is open or not in same Excel session

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

MatchIf_ThenDelete

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

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