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
May1
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
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
COUNTIFS as Rank
Simplest way to rank among peers. used COUNTIFS in case we need to add more ...
2022Jan1
Evaluate
Execute any command in Excel VBE, using Application.Evaluate to execute almost ...
2020Feb16
