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
Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...
2022Aug17
Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...
2019Jan4
Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...
2018Jun27