Category Archives: VBA

Commenting a block of code in VBA

Posted on 26/09/2013 by dougaj4

One way is to manually place an apostrophe at the start of every line in the block. A much easier way (I just found out today) is: Go to View-Toolbars-Customise Select the Command tab Select the Edit Category on the … Continue reading →

Posted in Excel, VBA | Tagged , , | 9 Comments

Python for VBA users – 1

Posted on 24/09/2013 by dougaj4

Following my recent posts on some preliminary experimentation with linking Excel to Python, this will be the first of a more structured series, mainly as a reminder to myself of lessons learnt on the way, but also I hope of … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | 2 Comments

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