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
API in ASP Classic
A simple REST API technique reading record from Access mdb, then generates json ...
2019Feb1
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30