In a recent project I needed the range of the Grand Totals in any pivottable in Excel. Unfortunately the PivotTable object has no property for this. Solutions I found on the Internet were for specific cases. So I developed a generic solution that I want to share with you.
[Read more…] about The Grand Totals range of a pivottable in ExcelVBA
How to set Excel’s ActivePrinter using VBA?
Recently I wanted to change Excel’s ActivePrinter using VBA. That isn’t as straightforward as I expected it to be. In particular there is a localization issue.
[Read more…] about How to set Excel’s ActivePrinter using VBA?