Adds or remove zeros at start of string Used to clear heading zeros from ...
2019May31
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31
Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...
2018Jun2
Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...
2020Nov11
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Filter table inside Excel the fast way (using advanced filter) into another ...
2022Sep15
RBU simply means "Registry Back Up" and is a tiny BAT (batch) file that will ...
2020Sep15
Get a sorted list of files in a directory using the File System Object (FSO) ...
2020Aug11
Pure CSS box shadow effect A Pen created at CodePen.io. You can find this one ...
2019Jan17