Search results 67

Sorted from new to old.
Card image
VBInstr (or Instr parameters)

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

Card image
Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

Card image
ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

Card image
AmIMobile

Check if browser is for a mobile or tablet, or not. This was before we have ...

Card image
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

Card image
SettingRead_JR

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

Card image
CellRead (SimpleLookup)

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

Card image
File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

Card image
MatchIf_ThenDelete

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

Card image
Match4

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

Card image
Match3

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

Card image
Match2

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

Card image
HMatchIf

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

Card image
MatchIf (aka VMatchIf)

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

Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image
CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...