Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
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
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...
2018Jul14
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22