Category Archives: VBA

Arrays vs Collections vs Dictionary Objects (and Dictionary help)

Posted on 29/08/2013 by dougaj4

A recent comment by Lori Miller at Daily Dose of Excel suggested that (for the particular application being discussed) the VBA Collection object was quicker than using scripting dictionaries.  Since I hardly ever use collections (other than the built-in ones), and … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , | 7 Comments

Running VBA routines from a new workbook

Posted on 21/08/2013 by dougaj4

I have had a couple of queries recently which seem to be resulting from trying to run User Defined Functions (UDFs) from a new workbook, so this post will look at the options for using the VBA routines provided here (or … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 1 Comment

Select and sum data using the scripting dictionary

Posted on 10/08/2013 by dougaj4

Another User Defined Function (UDF) prompted by a query at Eng-Tips. The question concerned a set of data consisting of 13 columns, which was to be divided into two sets, based on the contents of Column 4, then the contents … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 2 Comments

EvalA update and examples

Posted on 06/08/2013 by dougaj4

The EvalA User Defined Function (UDF) has been included in the Eval2 and Eval-Integration spreadsheets for some time, but was not documented.  That has now been fixed, and both spreadsheets can be downloaded from Eval2.Zip (including full open-source code). The … Continue reading →

Posted in Arrays, Charts, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

SelectAv Function

Posted on 30/07/2013 by dougaj4

Suppose you have a spreadsheet range containing numerical data, and would like to find the average for a number of the most recent values, ignoring the highest (and/or lowest) values from the selected set. If you like using long array … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , | 3 Comments