Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Saves a workbook handling several scenarios and decide what to do based on each. ...
Aug9
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
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
Database functions, commonly used in my systems. Should be working for each ...
2019Apr14
Pure CSS box shadow effect A Pen created at CodePen.io. You can find this one ...
2019Jan17