Full and Part Summaries with the Dictionary

Creating summaries using the Excel VBA scripting dictionary is something you will want to learn. The dictionary is powerful and can summarise data very quickly. This blog post takes you through the process of using the Excel Scripting Dictionary.

Tags Excel, scripting dictionary, Sum, Multiple, Columns

Excel Copying Variable Columns with Array

My tassie friend Valario asked another interesting and engaging question. The question came from the blog post ‘Read Individual Columns to An Array’. The design of the code was a little bit static so Valerio’s question was as follows.

Another question just to ruin your night!

Tags excel, VBA, Evaluate, Columns, Variable, Range