Similar codes
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
ConcaUFO_RowsfromSheets
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
OpenAnyFile
Finally, can have one command to open any file using its default associated app ...
2022Jan28
CustomExcelMenu - FaceIDs
How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...
2018Jul19
