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
Dropdown button commands
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
2022Oct12
EnvironList
List of all variables of Environ It will populate them in sheet range starting ...
2021Jan12
DigitsORLettersOnly
Check if the string has special characters or not, only Letters or digits ...
2018Aug8