Codes Required

Card image cap
IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Jul24

Similar codes

Card image cap
TextPercentageMatch

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

2018Jun26

Card image cap
NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Feb1

Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

Card image cap
ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

Oct24

Card image cap
CutLeft

Cuts the left part respecting words, without cutting words

2018May30

Card image cap
WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

Card image cap
IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Jul24

Card image cap
WordsCount

Counts the words in a string (using spaces)

2018Apr23

Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Nov12

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Random Codes

Card image cap
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Card image cap
Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

Card image cap
RandomImage

Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...

2018Aug10

Card image cap
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22