Similar codes
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
O365 Blocked Macros
Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
RunFromShared
Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...
2018Aug9
Resize_Me2 + Resize_Me3
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
Custom Excel Right-Click Menus
Customizing Excel's right click menus The following code demonstrates how to ...
2020Mar21
LogoutALL
Logs out Linkedin by running two commands One will open new window to logout ...
2018Apr23
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
ImageRotate_IrfanView
Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...
2018Jul22
MP3GetInfo
Returning information on an MP3 file. Returns a type containing information ...
2018Jul11
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11