Codes Required
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
GenerateRandom
Generates a random string, returns string passed, then full date, then 8-chars ...
2018Sep12
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
HTML_CleanNumber
Cleans block of string (HTML block) from characters that are not needed Can ...
Jan31
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
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9