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
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31