Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- Frame Analysis with Excel 1 - Single beam
- The history of the theory of beam bending - Part 1
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Function roots with the Inverse Quadratic Method
- Contour plots with Excel and Matplotlib
- Frame Analysis with Excel - 4, 2D frame analysis
- Latex Maths Text in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Tag Archives: ByVal
IP2 Update, ByRef and ByVal
A recent comment pointed out that the IPPlaneLine function (intersection of a 3D line with a plane) in the IP2 spreadsheet was giving incorrect results. This has now been fixed, and the corrected spreadsheet can be downloaded from IP2.zip. The problem turned out … Continue reading
Transferring data with arrays
The earlier post: Transferring data within VBA looked at some important aspects of transferring data between subroutines in Excel VBA. This post will look at arrays in particular, and some peculiarities that affect the way they work. VBA arrays are a very … Continue reading
Transferring data within VBA
The use of inappropriate techniques for passing data between sub-routines and modules is probably one of the most frequent causes of error in VBA programs, but many text books provide little guidance on this subject, and what there is, is … Continue reading