Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
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
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Bootstrap side navbar (sidebar)
Can be pushed to left or right
From
2019Aug8
Show or hide Excel ribbon from inside VBA Needed that in one of my projects
2018Dec30