How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
Simple command to know which object (shape) the user clicked When you assign a ...
2022Feb4
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Detects active desktop screen resolution and location of taskbar (with some ...
2018Jun17
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
How to use gsplit to split large files into smaller parts to allow to read it. ...
Feb7
Looks like there is a bug in Excel when dealing with copy and paste. Excel ...
Dec27
Calculate colors close to input color, a jquery html that will give you 10 ...
Nov8
Generates thumbnail of an image and saving it in certain folder. Edit php to ...
2020Dec24