Author Archives: dougaj4

XLDennis, the MSDN Library, and VBA rant

Posted on 04/10/2011 by dougaj4

Dennis Wallentin, aka XLDennis, is a long time contributor to the on-line Excel community and co-author of the latest version of Professional Excel Development.  In recent years he has concentrated on the use of the VSTO and .NET products in … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , | 13 Comments

Inserting a list of names

Posted on 28/09/2011 by dougaj4

Another function that I don’t use much, and that got hidden by the Ribbon, is the command to insert a list of named ranges together with the addresses they refer to. Here’s where they hid it: On the Formulas Tab, … Continue reading →

Posted in Excel | Tagged , | 1 Comment

More on writing arrays to the worksheet

Posted on 28/09/2011 by dougaj4

Writing a large VBA array to the worksheet in a single operation, rather than cell by cell, can result in a huge improvement of the speed of many macros.  The basic technique was described here.  I recently wanted to modify this … Continue reading →

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

Using the Strand7 API

Posted on 23/09/2011 by dougaj4

Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results.  The API is a comprehensive … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 7 Comments

Flipping Coin Problems

Posted on 15/09/2011 by dougaj4

At Daily Dose of Excel Dick K. looks at a VBA solution to this problem: Problem description: Take a stack of coins all heads up. Upturn the topmost coin, place back on the stack and then proceed: take the top 2 … Continue reading →

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