Recent Comments
Tag Archives: VBA
Adding Function Categories and Descriptions
User defined functions (UDF’s) are by default added to the “User Defined” category in the function list, and when a UDF is selected the words “no help available” appear, rather than a description of the function and it’s parameters. A rather … Continue reading
Some string functions
It was pointed out in a comment to this post at Daily Dose of Excel that VBA has a StrReverse function that will (logically enough) reverse a string. That’s not awfully useful to me (except maybe for Project Euler), but it … Continue reading
Frame Analysis with Excel – 7; Shear deflections and support displacements
Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
31 Comments
Moving Average Function
The previous post presented a simple moving average user defined function (UDF). This has been extended to provide additional functionality: A weighted average may be returned; either a linear weight with a specified step value, or a using any specified weighting … Continue reading
Moving averages and User Defined Array Functions
I have recently needed to work with moving averages on a large-ish data set (about 10,000 rows x 10 columns), and for reasons that I will describe in the next post, decided that a User Defined Function (UDF) would be … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Array Function, Excel, Moving Average, UDF, VBA
8 Comments
Newton Excel Bach, not (just) an Excel Blog 