Codes Required
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
RowList_Matching
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
ShapeName clicked
Simple command to know which object (shape) the user clicked When you assign a ...
2022Feb4
