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
Functions to convert two bytes to a numeric value (long), (both little-endian ...
Jan14
JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...
Aug11