Similar codes
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
ArrayRead + ArraySave
Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...
2018Apr15
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
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
Feb8
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Latest records date and count
Find how many items in table, with column DateAdded is the latest DateAdded in ...
Nov2
ForegroundColor
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
May5