Similar codes
O365 Blocked Macros
Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
MinIF and MaxIF in Excel 2010
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1
OneDrive Reset
Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...
Mar5
Window off-screen
Window not shown while taskbar says it is on. Restore window position in ...
2020Mar17
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
RunFromShared
Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...
2018Aug9
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17