Similar codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Custom Excel Right-Click Menus
Customizing Excel's right click menus The following code demonstrates how to ...
2020Mar21
ChartMaxY + ChartMinY
Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...
2018Aug16
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
UnixDateTimeNumber
Calculates Unix date/time number of a given date/time. Needed it to pass ...
2023Jan6
DosCommand_Read
Get output of DOS Command in string, by reading output into temp text file, ...
2018Jun22
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23