Recent Comments
Category Archives: Arrays
Extracting selected data with array functions.
This post is in response to a query at the Eng-tips forum asking how to extract selected data from a range, so that the three best scores for each individual could be extracted from a two column Excel table listing multiple individuals, … Continue reading
Using UDFs – Continuous Beam Example
Recently (well a month ago) a comment was left at Continuous Beams with Shear Deflections asking for a tutorial on how to use the ConBeam User Defined Function (UDF). In this post I will give detailed instructions for the ConBeam function, but similar … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
Leave a comment
Modifying spreadsheet data with VBA – the quick way
A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading
Writing Arrays to the worksheet – VBA function
Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading
VBA code generation on the spreadsheet
A previous post looked at using VBA to generate more VBA code. This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged API, code generation, Excel, Strand7, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 