Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1
Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...
Mar5
Window not shown while taskbar says it is on. Restore window position in ...
2020Mar17
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
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
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
A good dropdown select, with HTML code
From
2019Jun26
CSS Sub-menu (include example for Bootstrap) It also has custom html dropdown ...
2019Jan16
Generate random using web service into ASP variable. With help of PHP, we now ...
2018May13