Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
This will limit the number of characters a user types in a textarea.
2018Apr18
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1
Find the user name (and domain) for logged in user for in an internal intranet ...
2020Feb23
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...
2022Aug17
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
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
Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...
2020Nov11
Save into registry, read from registry or delete a key. Accessible to only ...
2019Jun15