Tag Archives: UDF

Charts and Charting

Posted on 27/01/2013 by dougaj4

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading →

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

Extracting a hyperlink

Posted on 21/01/2013 by dougaj4

Excel does not have a function to extract the address from a cell containing a hyperlink.  Here is a short UDF that will do the job: The original was a one-liner posted by Rick Rosthstein on Debra Dalgleish’s Contextures Blog.  I … Continue reading →

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

The angle between two vectors, in 2D or 3D

Posted on 12/01/2013 by dougaj4

Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference.  In 3D it is not so obvious, but it can … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 9 Comments

Tanh-Sinh Quadrature V4.0

Posted on 03/01/2013 by dougaj4

Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 6 Comments

Automating chart scale limits – update

Posted on 25/11/2012 by dougaj4

I wrote about this function 2 1/2 years ago, and promptly forgot about it, but a few days ago brian provided an answer to a question that was raised shortly after it was first posted, concerning how to apply the function … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , , | 13 Comments