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
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Converts an image from any image into any image using IrfanView command line ...
2019Jun26
Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...
2018Jul14