Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Similar codes
ArrSort_2Arr
Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...
2018Oct1
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
ArrSort_4Arr
Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...
2023Apr14
LstCustomSelection_Refresh
Read list of items from Settings sheet, then Sort, then save, before reading ...
2022Aug31
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
FindAncherURL_InHTMLRow
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
Mar4
Protecting VBA code
Steps to protect VBA project in Excel, posted here for reference mainly. An ...
2022Jul6
FeeKey + UnFeeKey
Protect Numbers by encoding them into Alphabetic And convert them back ...
2020Nov11
