VBA-Excel 284 Visual basic for applications that works only in Microsoft Excel, aka macros
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
PivotTable_ShowHideBlankItems
Shows or hides an item or items in a PivotTable filter field. Passing ...
ConcatenateStrings_AmongString
Collect strings matching search from a longer string. I used it to concatenate ...
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
ChartLegendCenter
Put chart legend at center of chart horizontally. Changes left and width only. ...
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...