Codes Required
VBInstr_Numeric
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
Similar codes
NumberBeforeString
Cuts a number that would be found before certain word inside a block string. ...
Feb1
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Arabic VS Hindi numbers
Settings to force Microsoft Word to show Hindi numbers with Arabic text, or ...
2019Jan14
SearchinHTMLTable
Search for a word in a certain column in html table and return the full row ...
Nov12
NumberFoundinsideTag
Checks if a number found between two characters, searching can be customized to ...
Aug21
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
CopyDynamicRangeValue
Copy values from range to cell. Without using clipboard of course. Here the ...
Aug10
Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...
2020Oct13
