VBA-Excel 281 Visual basic for applications that works only in Microsoft Excel, aka macros
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. ...
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...