VBA-Excel 326
Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Send workbook as email attachment
Retro way to send a workbook you are in as an email. Found it in one of my old ...
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. ...
