Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Cuts a number that would be found before certain word inside a block string. ...
Feb1
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Adds to daily log, two cells, one with date, next with activity that will be ...
Dec2
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
May5
Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...
2023Apr14
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
To raise a friendly error message with option to show custom error number and ...
2018Jul7
Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...
2018Apr25
Returns a formatted version of file 'LastModified' date. Pass parameter ...
2018Apr25
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Bootstrap checkbox with font-awesome (BS-FA Checkbox)
From
2019Jul30
Convert SVG files into GIF preserving the transparency, in bulk ' Used to ...
2019Sep5
Bootstrap, Font Awesome rating stars system, to replace options for users to ...
2019Sep26
kartik star rating system using Bootstrap and Font-Awesome
From
2019Jun23
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...
2023Jan31
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
Pure CSS trick to show a blurred background area behind a div Not my work, ...
2019Jun15
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10