Recent Comments
Category Archives: Excel
Area from Vectors
The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates. In this post the functions will be extended to find other section properties (such … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Area, coordinates, Excel, section properties, UDF, VBA, vectors
5 Comments
Dots and Crosses
The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors. Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged cross product, dot product, Excel, UDF, VBA, vector area, vectors
11 Comments
Section Properties from Coordinates Without VBA
At the Eng-Tips forum there was a question asking for a calculation of area and centroid values from coordinates without the use of VBA. In my opinion using VBA is much the easiest and most robust way to do it, … Continue reading
Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA
Tagged Area, Centroid, Excel, section properties, UDF, VBA
13 Comments
Importing selected rows from a text file
I was recently asked if the routine in the Text-in2 spreadsheet to import and split data from text files could be modified to only import rows that met specified criteria. A similar end result can be achieved by importing the whole … Continue reading
Debugging VBA – 2
Following on from the opening post in this series (Debugging VBA) I will now look at the main debugging tools provided in the Visual Basic Editor (VBE): The Immediate Window allows interaction with the code while it is running. In the … Continue reading
Posted in Excel, UDFs, VBA
Tagged Debugging, Excel, Immediate window, UDF, VBA, watches window
Leave a comment
