Tag Archives: Excel

The speed of loops

Posted on 07/03/2010 by dougaj4

Commenting on the Good Practice post, John Tolle pointed out that with a collection it was very much quicker to loop using a For each loop than iterating by index, using a for, next loop.  I did some simple tests on this, … Continue reading →

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

Stringing more than two words together

Posted on 01/03/2010 by dougaj4

It has always seemed strange to me that the Excel function Concatenate(), which has such a long name, provides no additional functionality over using the & operator. The TextString function is a simple User Defined Function (UDF) which provides the … Continue reading →

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

Transferring data within VBA

Posted on 25/02/2010 by dougaj4

The use of inappropriate techniques for passing data between sub-routines and modules is probably one of the most frequent causes of error in VBA programs, but many text books provide little guidance on this subject, and what there is, is … Continue reading →

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

Secondary axes in Excel 2007

Posted on 20/02/2010 by dougaj4

Sometimes rarely used features in an application are so prominently placed that we become blind to them, and can’t find them when we need them. This happened to me recently with the procedure for assigning an Excel chart series to … Continue reading →

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

Hello World (again)

Posted on 02/02/2010 by dougaj4

Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading →

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