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
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
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
Remove tags that are identical and nested inside each other in an HTML document, ...
Feb4
ASP.Net ShowThumb.aspx file that generates image thumb from an image, official ...
2018Sep19