Category Archives: VBA

High Speed Blog …

Posted on 07/06/2011 by dougaj4

… brought to you via Smurf on Spreadsheets If you want your spreadsheets to go faster, Charles Williams is the man to tell you how to do it.  Charles has recently started a blog on the subject: FastExcel Well worth … Continue reading →

Posted in Excel, VBA | Tagged , , | Leave a comment

Using LinEst() on data with gaps

Posted on 14/05/2011 by dougaj4

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps.  There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 40 Comments

Showing numerical values of formulae cell references

Posted on 28/04/2011 by dougaj4

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula.  It is easy to display the formula, rather than the result, for all the … Continue reading →

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

Beware of the mod

Posted on 22/04/2011 by dougaj4

Playing with a simple VBA user defined function (UDF), inspired by a thread at Daily Dose of Excel, I was finding it was mysteriously giving the wrong answer. The task was to find the angle between the hands of an … Continue reading →

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

Calling Add-in functions from VBA

Posted on 16/04/2011 by dougaj4

When an Excel add-in is active any User Defined Functions (UDFs) in the add-in are available to any other open worksheet.  It might be expected that the same would apply to VBA routines defined in other files, but if you … Continue reading →

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