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
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
CreateZipFile_7Zip
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14