Category Archives: VBA

You can’t count on money

Posted on 28/02/2009 by dougaj4

An interesting bug is reported at Daily Dose of Excel: Code snipit to test If you use a variable of data type currency as a counter in VBA you get some very strange behaviour.  The function below returns the result … Continue reading →

Posted in Excel, VBA | Leave a comment

IP.xls updated

Posted on 16/02/2009 by dougaj4

The spreadsheet IP.xls has been updated (previous post) with the addition of a function to find the minimum perpendicular distance from a point (or series of points) to a polyline: Pdist =PDist(Line,Points) Line is a range with at least two rows containing … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | 1 Comment

Frame Analysis with Excel – 4, 2D frame analysis

Posted on 15/02/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download Frame1.zip – the download file includes complete open source code. The continuous beam spreadsheet presented in the previous post has been modified to deal with 2D frames where any … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, Uncategorized, VBA | Tagged , , , | 20 Comments

Multiple Match Function

Posted on 11/02/2009 by dougaj4

The Excel function MATCH() will find the position of the first occurrence of a specified number or string in a range of data, but what if you want to find the first row in a table that contains two or … Continue reading →

Posted in Excel, UDFs, VBA | 5 Comments

Frame Analysis with Excel – 3, Continuous beam or frame

Posted on 10/02/2009 by dougaj4

Continuing from Frame Analysis with Excel 2 – Single inclined beam Download Beam3.zip – the download file includes complete open source code. The spreadsheet for a single inclined beam presented in the previous post has been modified to deal with up … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 30 Comments