Similar codes
NMRRank_v2021
Ranks a number among set of numbers. This is part of huge tool, we needed to ...
2021Sep23
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
CleanArray
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
InsertHyperlinks + GetHref
Converts https found in text into anchers < a > Comes with GetHref as bonus ...
2018May13
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Send page to print
JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...
Aug11
Too large procedures
No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...
2022Jan29
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Weighted_Average
Does a weighted average, knowing that mathematical average between two numbers ...
2018Jul7