Recent Comments
Tag Archives: Excel
Equivalent Stress Blocks
Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged AS 3600, Eurocode 2, Excel, Rectangular stress block, Reinforced Concrete, UDF, ultimate moment capacity, VBA
4 Comments
Spreadsheet Solutions For Structural Engineering
Another site where the tasks considered suitable for programming in Excel and VBA are anything but “boring and repetitive” is Yakpol’s Spreadsheet Solutions For Structural Engineering: “This web site contains a collection of engineering spreadsheets for structural analysis and design of concrete and … Continue reading
Posted in Beam Bending, Excel, Newton, VBA
Tagged Excel, Structural Engineering, VBA, Yakpol
2 Comments
More on VBA
Andy Pope posted the two links below in a comment to my previous post: A while back they added a VBA developer center to the msdn Office site. http://msdn.microsoft.com/en-gb/office/ff688774.aspx And this article on the Excel developer road map is interesting. … Continue reading
Posted in Computing - general, Excel, VBA
Tagged Autocad, Excel, Gnumeric, Google Docs, Intellicad, Open Office, VBA, VSTA
Leave a comment
XLDennis, the MSDN Library, and VBA rant
Dennis Wallentin, aka XLDennis, is a long time contributor to the on-line Excel community and co-author of the latest version of Professional Excel Development. In recent years he has concentrated on the use of the VSTO and .NET products in … Continue reading
Posted in Computing - general, Excel, VBA
Tagged application development, Excel, VBA, VSTO
13 Comments
Inserting a list of names
Another function that I don’t use much, and that got hidden by the Ribbon, is the command to insert a list of named ranges together with the addresses they refer to. Here’s where they hid it: On the Formulas Tab, … Continue reading
